Excel Lookup
How to fix anything
 
 
 
 
 
 

Search for :



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


Previous Page    Next Page    IP

_________