I am trying to do a VLOOKUP between two seperate workbooks, one has a column of cert numbers and a column that is to be filled with the vlookup. My other workbook has 30+ columns, the first column is the one that also contains cert numbers.
When I do the VLOOKUP, I select everything correctly but somehow it returns N/A to me for 3/4 of the info and I get the other 1/4.
I have checked the numbers that return N/A and if I do a search for it in the workbook, it appears. So why is the VLOOKUP not returning a value?