asked on
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
A=fname
B=lname
H=pull from email
tab regs
A=lname
B=fname
G=email
so in teams I want column h to be a lookup that pulls column G from regs when the fname & lname matches
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
A=fname
B=lname
H=pull from email
tab regs
A=lname
B=fname
G=email
so in teams I want column h to be a lookup that pulls column G from regs when the fname & lname matches
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
Last Comment
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Also, you could use vbscript to help with it, here's a link to a guide on it:
http://excelspreadsheetshelp.blogspot.com/search/label/LOOKUP
http://excelspreadsheetshelp.blogspot.com/search/label/LOOKUP
ASKER
not vlookup?
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.
Add Column A to both sheets, set to =Concantenate(B2," ",C2) in both A Columns
Then do your vlookup off that.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Open in new window