Excel Lookup

0

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

Share.

About Author

Comments are closed.

Please note we do not accept any responsibility for errors occurring During Use of this site users follow instructions listed at their own risk.