Vlookup a value and text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=vlookup(text(a1,"general"),lookup_range,column number,0)
where A1 is number that you are seeking in the lookup range as text
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookups and formats 3
vlookup with numbers 10
Can't Explain N/A in Vlookup 2
VLOOKUP 1st Friday in April and So On 1
VLOOKUP isn't working properly in Excel on Mac 1
vlookup to find match only part of a text value 3
Vlookup - value not formula 1
VLookup and text strings 3

Back
Top