Hi,
vlookup table reference are mixed text and numbers in excel. Am trying to vlookup value return N/A.
I would like the Vlookup amended so that If the numbers are stores as text on sheet.
The both of sheets as numbers/text on the sheet using the vlookup formula, it will return the correct information.
Your assistance in this regard is most appreciated.
file attached.
Bookmarks