| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup for same name, multiple instances...
Hi Pete,
yes, exactly! "Pete_UK" wrote: How do you want them to appear in Sheet1? Do you want to get Smith in column B and Robertson in column C then Berg in column D etc? Pete On Feb 6, 10:15 am, Maria wrote: Hi all, I have the same problem. I am trying to lookup the value of one sheet, in another sheet. Example: Sheet1: Column A Andie Sam Mary John Carlos Sheet2: Column A Column B Andie Smith Claudia Mensi Michele Castro Andie Robertson Mary Johnson Andie Berg So I want to look up Andie in sheet2, and get the multiple results in sheet 1. Any ideas? Many thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VlookUp with Multiple Criteria? | Excel Worksheet Functions | |||
| vlookup with multiple lines of same value | Excel Worksheet Functions | |||
| vlookup over multiple worksheets | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
| Multiple Vlookup? | Excel Worksheet Functions | |||
Threaded Mode
