Can you post some sample data of the lookup values, and the lookup column in
the table array (1st col) ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dvnmaya" wrote in message
...
This is great I've been trying to figure it out for a while BUT...now I'm
trying to use the resulting number (the phone #) to do a VLOOKUP and it
won't
work because it is text...is there an easy way to make this compatible for
a
VLOOKUP (without manually changing each one)
cheers,