I am asked this many times, so here is a sample.
1. How can an excel spreadsheet lookup a value in another excel spreadsheet?
2. A value from a different column in the looked up sheet is required, when the row is found
The sample works using the 2 functions :-
• match (returns the row number where the value is found)
• index (returns the value of one cell from a range of cells)
This method can be used when the lookup sheet is the same Excel Workbook or in another Excel File
CLICK HERE TO DOWNLOAD THE SAMPLE SPREADSHEET