vlookup not looking up text

  • Thread starter Thread starter mpcluever
  • Start date Start date
M

mpcluever

i have a range of cells containing card names and prices. Looking t
use vlookup to look down the left column and return the price. i
doesn't recognise 2 identical text cells. i even trie
=CODE(MID(ID1,1,1))&CODE(MID(ID1,2,1))&CODE(MID(ID1,3,1)) to conver
the text to a numeric code and again it doesn't recognise it.

Blessed Reversal $1.00
Elite Archers $1.00
Glorious Anthem $3.00
Intrepid Hero $2.00
Kjeldoran Royal Guard $1.00
Master Healer $1.00
Northern Palladin $2.00
Pariah $2.50
Purify $2.00
Reverse Damage $1.00

any help
 
What is the "text cell" that it fails to find?? Also, take an empty cell
and write the formula =(cell1 - cell2), where one of these cells is your
test cell, and the other is the corresponding cell in the table. Are they
really the same?? Look for a trailing space. This might cause the cells to
appear to be the same, but they aren't.
 
Assume your table starts in A1 of sheet1

=vlookup("Blessed Reversal",Sheet1!$A$1:$B$10,2,False)

if that doesn't work, you might have trailing spaces on Blessed Reversal as
an example. Remove the trailing spaces.
 
Back
Top