CODEWITHSUNDEEP
excelvlookup
GWS
GWS

Reputation: 21

Vlookup #N/A error but value exist in table array

I have an Excel file that I'm trying to get help on why my vlookup formula is creating #N/A so how do I attach an excel file for posting on this forum?

I have a table that I'm trying to get the ItemLookup column to correspond to the ID column but I'm getting #N/A errors for quite a few of them. I would attach the file but I don't see an option on how to do this in the forum.

Upvotes: 0

Views: 13398

Answers (1)

GWS
GWS

Reputation: 21

I ended up looking online and found that my data in each column needed to be the same. Once I did Data > Text to Columns > Finish and had the data formatted as the same type the vlookup worked.

Upvotes: 2

Related Questions