In the data below I attempt to find items in column C and return date in
column B
using =VLOOKUP(C2, A9:C11, 2, FALSE)

A B C
1 NMR-2438 2/6/08 21098
2 NMR-2439 2/13/08 D817
3 NMR-2467 2/15/08 070321E

Problem is that column C type is 1 (number) or 2 (text).
I need then to convert C data to text, like C2&"", or text(C2, "").
But then vlookup needs to look in column C and covert at the time of search.

Is there a way to write the vlookup to do both value to lookup and range
value conversion to text?

Thank you.