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.
Thank you for your help.
This index formula has fixed the error and given the correct result 