View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default How to MATCH value up a column

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" wrote:

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