Vlookup a value and text

R

raboone

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.
 
N

N Harkawat

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