Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 36

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 46

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 52

Warning: Use of undefined constant id - assumed 'id' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 54

Warning: Use of undefined constant count - assumed 'count' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 58

Warning: Use of undefined constant debug - assumed 'debug' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/sqlfunctions.php on line 184

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 449

Warning: Use of undefined constant pw - assumed 'pw' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 515

Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/menu.php on line 3

Warning: Use of undefined constant type - assumed 'type' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/search.php on line 3
Excel Lookup
How to fix anything
 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
    IP

©Copyright HPC Solutions Limited - All rights reserved (2012/13) .
Please note we do not accept any responsibility for errors occurring During Use of this site users follow instructions listed at their own risk.