View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dungan dan dungan is offline
external usenet poster
 
Posts: 411
Default what formula can i use to find a specific value?

I ended up using this formula:

=VLOOKUP(K2,table2Proprietary!A1:T53,VALUE(MATCH(G 2,table2Proprietary!
A1:T1,FALSE)),FALSE)