Forum Discussion
VLookup #N/A Error
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.
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 C5:C14.
Other words, VLOOKUP() always works from left to right.
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.