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
Previous Page Next Page IP