 |
| |||
|
Google this page is not a duplicate Excel Lookup 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 
IP | ||||
|
||||