We help IT Professionals succeed at work.
Get Started

Excel - Vlookup array for multiple spreadsheets

kvrogers asked
Last Modified: 2015-06-08
I am attaching an example of the file using only 2 of the 12 spreadsheets.

Here is what I need:
I need to populate COLUMN Q on the tab named FPOassign.

That should be based on matching the Subscriber # in Column O tab FPOassign with the Subscriber number in Column M over on the CAP tab and resulting whatever is in column AC on the CAP tab into Column Q on the FPOassign tab.

If  the subscriber number in in both spreadsheets is the same then populate the Subscriber # in the FPOassign spreadsheet with the Internal Assigned mnemonic.  assigned to that Subscriber #.

Example:   every time that Subscriber Number 1383 matches both the CAP and FPOassign spreadsheets then in the FPOassign spreadsheet in Column Q it will show JDS for every match.  

I was doing some research and was not sure if I should use an IF statement OR a VLOOKUP .   I don't have much experience with either.
Watch Question
Consultant (Development Team Lead, Senior Support Engineer, and Technical Test Leader)
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE