VLOOKUP and data formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've copied data from a spreadsheet on a website and pasted it into my
spreadsheet.

I used VLOOKUP to compare this single column of information (text) with a
table within the spreadsheet but it won't find the exact match. If I type in
the text (vs. the cut and paste of the same information), the match is found.
I've changed everything form text to general, tried to fool the system by
using copy/paste special/ multiply and multiplying things by 1 to force a
format change but nothing will make the two data types comparable.

I don't want to have to type in each line but it will work if I don it.

Any ideas?
 
I would have expected the muliplication by 1 to solve this, if the problem is
solely what you described. Still, I'll assume that is the problem, and
suggest that you can force the type conversion within the vlookup function.
Ex: instead of =vlookup(a1,table_array,2,false), use
=vlookup(value(a1),table_array,2,false).
 
Good ideas. Thanks.

bpeltzer said:
I would have expected the muliplication by 1 to solve this, if the problem is
solely what you described. Still, I'll assume that is the problem, and
suggest that you can force the type conversion within the vlookup function.
Ex: instead of =vlookup(a1,table_array,2,false), use
=vlookup(value(a1),table_array,2,false).
Click to expand...
 
Back
Top