How to MATCH value up a column

[DevourU]

I need to match/find the first matching cell up a column. Ideas? TIA!

 

[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

 

[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

 

[DevourU]

Ignore "display next column B4". That's something else. Sorry 'bout that.