Hi All,
Index Match is easy when your data is on known columns but here is different scenario.
How do I pull ID and School name from many different columns on sheet2.
e.g. If I type the Name of a student on sheet1, and I get the ID and School name that are located on Sheet2.
Thank All.
Bookmarks