VLOOKUP Problem

[sakinen]

I have a little bit of problem with lookup function. When i paste values from another worksheet (paste special, values) in a cell which is lookup value i get #N/A. These values are numbers. When i put '7 for example i get the values i want from lookup table. I have a lot of these cells and its tedious job to put ' in front of every value. Is there a quicker solution?

[daddylonglegs]

You can convert the number to text with the VLOOKUP formula by concatenating "" to the lookup value, for example if your VLOOKUP is currently

=VLOOKUP(A1,B1:C10,2,0)

change to

=VLOOKUP(A1&"",B1:C10,2,0)

[Ron Coderre]

Two approaches come to mind....

1) Change the lookup table so the first column contains numbers, instead of numeric text.

2) After pasting the values into the cells (and assuming you're pasting a column of values), try this:
• Select the range of pasted values
• Data.text-to-columns
...Click: Next
...Click: Next
...Check: Text
...Click: Finish

That will change the pasted values to text.

Does either of those suggestions help?

[sakinen]

Does either of those suggestions help?

Please Login or Register  to view this content.

This one helped. Thanks a lot guys!