Vlookup error

[johnpearson67]

I have a vlookup in one spread to look up qty's in another and is erroring #N/A.
when I go to the lookup table and click in the cell and hit F2 and enter the error goes away.
so I then try to copy this down and I have to go cell by cell hitting F2 enter. not changing anything.
is there some remedy to have to Hit F2 all the way down spreadsheet?
I know it has to do with formatting so I copied the formatting from one to the other and that didn't work either.

 

[Joe4]

Welcome to the Board!

Are the values that you are matching on numbers?
If you have numbers entered as text, and are trying to compare them to numbers entered as numbers, it won't work.
They need to be formatted exactly the same way (hitting F2 is equivalent to re-entering and may be fixing that).
Using Text to Columns on the whole column at once may fix that whole and solve your issue.

 

[johnpearson67]

I wished I would have asked this board sooner. Worked like a champ. thank you so very much.
I feel like a newbie now. lol

 

[Joe4]

You are welcome.
Glad we could help!

Yes, its those little things about VLOOKUP that can drive you mad! Don't feel bad, we have all been there at one time!