Excel Lookup
 Windows Fix | About Us | Which Computer? | Memory Stick | Copy File | Site Map | 
What is a Browser
 | Search Engine | Windows Explorer 


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

_________

How to fix anything