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
|