need Help with EXEL
This is a discussion about need Help with EXEL in the Warp2search Hang Out category; 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.
This topic was started by 24518f9903e3c3d5891f4cc2012e80afdb9f50e8, . Last reply by Tuckwit,
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
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
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
Responses to this topic
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
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
OP
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
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
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)
Ich speche kien deutsche (or something like that)
