How to fix anything

Search for :


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

Lookup Spreadsheet Sample Code
    IP