comparing 2 files with Vlookup possible?

  • Thread starter Thread starter dindigul
  • Start date Start date
D

dindigul

I have been asked to use Vlookup to flag similar entries in two files using
vlookup. Is it possible? Thanks
 
An easy way to do this is to start your formula and then select the other
area and then touch the enter key.
=vlookup(a2,
now open the other file >goto the lookup range>highlight it>touch the enter
key>complete the formula.
 
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

in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Can't Explain N/A in Vlookup 2
VLookup not working - missing entries or not returning correct values 1
VLookup help, or similar function help, Please! 2
Formulas in Conditional Formula 5
vlookup from right to left 2
Excel IF statement with vlookup 2
EXCEL - IF(IFERROR(VLOOKUP question 0

Back
Top