vlookup to extract part cell content

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

Guest

hi all,
how to apply the formula =vlookup(A1,subjectArray,3) to read only part of
the cell in column 3 (say four digits from left).
i tried =vlookup(A1,subjectArray,left(3,4)). the result was the entire value
of that cell for example 123456789 and not 1234.
thanks for any help
 
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

Excel Vlookup Help 0
Vlookups and formats 3
VLOOKUP 2
Using Wildcards in VLOOKUP 3
vlookup useful? 2
EXCEL - IF(IFERROR(VLOOKUP question 0
vlookup only part of the string in the cell 3
Vlookup and Trace Return Cell 2

Back
Top