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 PinkstonAsked:
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor 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
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.
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.

All Courses

From novice to tech pro — start learning today.