Complicated vlookup example
Hi there,
I have a dataset where there are three different columns with names. I would like VLOOKUP or INDEX, etc to use those names (in 3 different columns) and search for all 3 against one column in another sheet. Once the matches are found, I’d like to get the contents in the column 8 rows to the right for all 3 names in one cell (so merged). Example, if I have names Sam, Sophia and Liz and the columns 8 rows to the right had the following
Sam – Jungle Group
Sophia – Safari Group
Liz – Forest Group
I’d like the input to return to be Jungle Group, Safari Group, Forest Group
Let me know if this is possible.
Hi there, I have a dataset where there are three different columns with names. I would like VLOOKUP or INDEX, etc to use those names (in 3 different columns) and search for all 3 against one column in another sheet. Once the matches are found, I’d like to get the contents in the column 8 rows to the right for all 3 names in one cell (so merged). Example, if I have names Sam, Sophia and Liz and the columns 8 rows to the right had the following Sam – Jungle GroupSophia – Safari GroupLiz – Forest Group I’d like the input to return to be Jungle Group, Safari Group, Forest Group Let me know if this is possible. Read More