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!
|