vlookup problem

  • Thread starter Thread starter mkk
  • Start date Start date
M

mkk

I am trying to a vlookup on formatted text. I I had a long string and
extracted certain characters from it using the "mid" function. Now if
do a vlookup on the extracted list it doesnt work. But if I were t
actually type in the values in the extracted list the vlookup start
working. I tried changing the format of the extracted list to general
number and text..nothing works.

Can anybody please tell me what I am doing wrong? I know my vlookup i
correct because it works when i type the values in the table array.

thank
 
Check to be sure your "MID" function doesn't introduce an extra "space" into
the result, that of course don't get there when you type the value
in..................

Vaya con Dios,
Chuck, CABGx3
 
You know it works if you type in the cell where your MID formula is, so, try
typing the string in a helper cell and doing a simple =A1 to get the string
into the cell where you now have your "mid" formula.......if it works then,
you have some sort of issue with your "MID" formula..........maybe just
re-enter it.

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top