Why is my VLOOKUP returning erroneous data?
I am using a cross-sheet VLOOKUP formula on several rows in a master sheet. It is working correctly in one column, but for the other column the formula is returning erroneous data for only a few rows. For instance, in a couple of cases it is finding a search value that does not exist in the referenced sheet, then returning an erroneous number. Why is this happening?
Help Article Resources
Check out the Formula Handbook template!