D
DevourU
I need to match/find the first matching cell up a column. Ideas? TIA!
E
Eva
Hi
I don't know what you are looking for, but see:
MATCH(A2,A1:F1,0)
or
VLOOKUP(A3,Sheet2!A:B,2,FALSE)
--
Please click "yes" if this post helped you!
Greatly appreciated
Eva
I don't know what you are looking for, but see:
MATCH(A2,A1:F1,0)
or
VLOOKUP(A3,Sheet2!A:B,2,FALSE)
--
Please click "yes" if this post helped you!
Greatly appreciated
Eva
D
DevourU
Thankx for the reply. Here is my
formula:=IF(A11>A10,C10,(IF(A11=A10,A10,"?"))).
I need to have IF(A11<A10, search up column A for 1st match, example A4,
display next column B4.
Clear as mud?
-JS
formula:=IF(A11>A10,C10,(IF(A11=A10,A10,"?"))).
I need to have IF(A11<A10, search up column A for 1st match, example A4,
display next column B4.
Clear as mud?
-JS
D
DevourU
Ignore "display next column B4". That's something else. Sorry 'bout that.