Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup a value and text
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. |
#2
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|