That does work but I was hoping to include it right in the vlookup formula.
Thanks,
Jodie
--
Jodie Gardner


"CLR" wrote:

If your Table has "spaces" in it's text strings and your origin cell does
not, then maybe try adding a new column to the left of your table and TRIM
the spaces out there, and modify your VLOOKUP to look for the origin in that
new column.

Vaya con Dios,
Chuck, CABGx3



"jodieg" wrote:

Hello!
I am trying to do a vlookup where the format of the origin cells are
"general" and the format of table array is all in text. I am looking up a
combination of alpha and numeric characters on the origin.
I know I can't look up 2 different formats but want the vlookup formula to
acknowledge the difference.
I tried the following formula but it does not work:
=VLOOKUP(C9,TRIM('[Copy of MP_Book.xls]Merge Purge
Results'!$B$9:$T$286),19,FALSE)
It returns an error of #N/A.
Any suggestions on how to get the table array of text to be matched with the
general value?
Thanks for your help!

--
Jodie Gardner