How to MATCH value up a column

  • Thread starter Thread starter DevourU
  • Start date Start date
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
 
Back
Top