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