View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to lookup a value in excel?

Thank everyone for suggestion

=INDEX(MATCH(MAX(B:B),B:B,0),A:A)
If I input this formula in cell C1, then it works fine, but if I input this
formula in cell C2, then it returns #REF!, could you please tell me how to
fix this value?
Thank everyone very much
Eric