Vlookup with more than 15 digits

  • Thread starter Thread starter Julie
  • Start date Start date
You will need the digits in text format otherwise Excel will change anything
after the 15th digit to a zero.

Enter the digits preceded by an apostrophe.


Gord Dibben MS Excel MVP
 
Hi,

=vlookup(A1,B1:D10,2,false)

your number is in A1
your table is in B1 to D10, value to be extracted in column C
 

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

Vlookup when lookup criteria is not an exact match 2
more than 15 numbers in a cell? 7
News Bank of England considers digital currency 4
Vlookups not working 2
vlookup or index/match formula?? 2
update vlookup formula sheet reference for multiple sheets 5
Excel IF statement with vlookup 2
Help With VLOOKUP 2

Back
Top