Hi all - my vlookups are not working - I am using retail SKU numbers on two different sheets and the vlookup is returning #N/A results for the whole table. An example of my vlookup is below:
=VLOOKUP(I4,Sheet1!$A$4:$E$42,5,FALSE)
I Have formatted both tables as Text and then tried it as Numbers. I also removed any spaces.
Does anyone have any tips or tricks on other things to try? This has happened to me a few times and I would love to find a solution.
Thank you!
Bookmarks