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.  

​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.    Read More

​