| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if, and, Vlookup functions - mutiple matchng
Hi I have 2 workbooks each with mutiple columns.
WRKBk1: First Name (B) Surname(C) Email Address (E) Wrkbk2 (reference source): First Name (A) Surname (B) Email address (C) I enter first and surname in to wrkbk1. I am looking for a function that will match match the two colulmns in WRKBk1 with the data in WRKBK2 and then extract the email address from 2 and put it into column (e) in workbook1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup on mutiple worksheets | Excel Discussion (Misc queries) | |||
| Need excel to do mutiple functions per row | Excel Discussion (Misc queries) | |||
| vlookup for mutiple rows | Excel Worksheet Functions | |||
| Vlookup Mutiple Values | Excel Discussion (Misc queries) | |||
| how do i get mutiple values using vlookup in excel, lookup value . | Excel Discussion (Misc queries) | |||
Threaded Mode
