Please may someone out there could help me. I been trying to figure out how to do this for a few days with no success. I have a name on sheet 2 cell A3, and I have a list of names on sheet 1 Column B, I need to return what is on column C on the same row number the name is on column B if the name on sheet 2 cell A3 Match the name on the list on sheet 1 column B. My result in the one cell should look like: 2002-2003 / 2004-2005 / 2006-2007 / 2008-2009 in one cell because that name in sheet 2 cell A3 is 4 times on sheet 1 column B, let said (B20, B100, B150, B200) and sheet 1 column C20=2002-2004, C100=2004-2005, C150=2006-2007, C200=2008-2007
Many thanks in advance. any help is really appreciated.
Bookmarks