=vlookup(text(a1,"general"),lookup_range,column number,0)
where A1 is number that you are seeking in the lookup range as text

"raboone" wrote in message
...
I'm trying to do a vlookup on two spreadsheets, the reference number is
formated as a number, the data source is formated as text. How can I
change
one of the number to either text or value to match the other one? I know
it
can be done with do a text to column funtion but I was hoping to be able
to
do it inside the formula.