• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

vlookup assistance

I have a workbook with two tabs (worksheets) team & regs

tab teams has multiple columns and I want to have a column pull email from tab regs when the fname and lastname columns match in each table.

tab teams
H=pull from email

tab regs

so in teams I want column h to be a lookup that pulls column G from regs when the fname & lname matches
Matt Pinkston
Matt Pinkston
  • 3
1 Solution
Brian HarringtonIT ManagerCommented:
According to http://www.mrexcel.com/forum/showthread.php?t=306615, you can use the index function for a multiple criteria function. Structure is thus:


Open in new window

Brian HarringtonIT ManagerCommented:
Also, you could use vbscript to help with it, here's a link to a guide on it:

Matt PinkstonAuthor Commented:
not vlookup?
Brian HarringtonIT ManagerCommented:
Vlookup only considers one conditional.  You look up by the left most column of your array.  If you'd like to use vlookup and are okay with adding a column, you could do this.

Add Column A to both sheets, set to =Concantenate(B2," ",C2) in both A Columns

Then do your vlookup off that.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

Index/match is much more powerful than Vlookup. Here's another version to do what you describe, starting in G2 and copied down.


see attached.

cheers, teylyn
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now