• About Us
  • Search
  • Compatibility
  • Forums
  • Archive
  • Channels
  • Home
  • Search
  • Member List
  • Calendar
  • Help

Current time: 12-04-2008, 10:09 PM Hello There, Guest! (Login — Register)


Warp2Search - Your Daily Tech News Service / General Discussion / Warp2Search Hang Out / need Help with EXEL

Post Reply  Post Thread 
Threaded Mode | Linear Mode
need Help with EXEL
Author Message
Mertsch
Super Moderator
******


Posts: 3,014
Group: Super Moderators
Joined: Aug 2002
Status: Online
Reputation: 1
Post: #1
need Help with EXEL

hiho,

I am searching for a formula ... but can't find it .... followin:

I have a database with for example 5xX and 4xY values .... so a 5x4 table
not the first line is a Date e.g. 1x1 = 01.01.2004 ... 1x2 = 02.01.2004 and so on
on line 2, 3 and 4 are spezific values recorded for that date
now I want to have a formula whicht selects the right value which fits to the date ..... for example I enter the date 02.01.2004 then it should paste the value from field 2x2

anyone know hat to do ??? I have searched through the various formulas but I haven't found the right one or I did something wrong ...

best regards



Avatar and signature by Eckpert @ Kackebeus.de
01-11-2004 07:32 PM
Find all posts by this user Quote this message in a reply
Tuckwit
Member
***


Posts: 65
Group: Registered
Joined: Sep 2002
Status: Offline
Reputation: 0
Post: #2
Not you again

And in return,

Say the cells are from A1 to B3

A1=01/01/2004, B1=02/01/04
A2=1, B2=2
A3=3, B3=4

Try =HLOOKUP(DATE(2004,1,2),A1:B3,3))

Would return 3

Have fun


~~~~~~~
MSI K8N Neo2 Platinum
Athlon 64 3200+ @2.3Ghz
Gigabyte 6800GT
2GB (HyperX & OCZ)
Audigy2
WinXP-SP2

This post was last modified: 01-22-2004 10:56 PM by Tuckwit.

01-22-2004 09:55 PM
Find all posts by this user Quote this message in a reply
Mertsch
Super Moderator
******


Posts: 3,014
Group: Super Moderators
Joined: Aug 2002
Status: Online
Reputation: 1
Post: #3
 

already found a formula .... just used the "normal" SUMMEWENN / SUMMIF
not that I SUMM something up but 0+ only the value gives only the value ...
and that what I want ..
also its quite easy to make
now its ...

=SUMMEWENN(5:5;C33;8:8 )

5:5 = dates
C33 = searched date
and the it takes the right field from line 8



Avatar and signature by Eckpert @ Kackebeus.de

This post was last modified: 01-22-2004 10:59 PM by Mertsch.

01-22-2004 10:56 PM
Find all posts by this user Quote this message in a reply
Tuckwit
Member
***


Posts: 65
Group: Registered
Joined: Sep 2002
Status: Offline
Reputation: 0
Post: #4
 

I gave the wrong first answer (should be Hlookup in english), then w2s crashed, have edited it, sorry about that.

Ich speche kien deutsche (or something like that)


~~~~~~~
MSI K8N Neo2 Platinum
Athlon 64 3200+ @2.3Ghz
Gigabyte 6800GT
2GB (HyperX & OCZ)
Audigy2
WinXP-SP2
01-22-2004 10:57 PM
Find all posts by this user Quote this message in a reply
« Next Oldest | Next Newest »
Post Reply  Post Thread 

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump:

Contact Us | Warp2Search.Net | Return to Top | Return to Content | RSS Syndication

Powered By MyBB
Copyright © 2002-2008 MyBB Group