VLookup #N/A Error

Question

My Vlookup formula returns a 'value not available error'.

Here is my formula:

=VLOOKUP(MAX(H5:H14),C5:H14,1,FALSE)

I want to search up the maximum value and return the name of the item.

martin_angosto · Answer

User0007728&nbsp;&nbsp;Try this instead:&nbsp;=INDEX(C5:H14,MATCH(MAX(H5:H14),H5:H14,0),1)

sergeibaklan · Answer

User0007728&nbsp;
For VLOOKUP() lookup value shall be in first column of the range. You take maximum in H5:H14, try to find it in C5:C14 (most probably it is not found) and return result from the first column in the range, i.e. again from&nbsp;C5:C14.
Other words, VLOOKUP() always works from left to right.&nbsp;

user0007728 · Answer

Thank you for your help. I can't rearrange this sheet but I will keep this in mind for next time it isn't working.

user0007728 · Answer

Martin_Angosto&nbsp;Thank you for your help.&nbsp;This index formula has fixed the error and given the correct result&nbsp;

martin_angosto · Answer

User0007728&nbsp;&nbsp;Glad it worked! 🙂

Forum Discussion

VLookup #N/A Error

Resources