|
|
#2
01-06-2011, 10:02 AM
|
|||
|
|||
Make the table you describe, where product is the first column and price is the second column. It is good, but not required, to sort this table ascending by product.
=VLOOKUP(C7,TableLocation,2,0) Vertical Lookup(WhatToLookFor,WhereToLook,WhatTableColToRet urn,IsCloseOK?) Don't forget to make the table location be absolute (either with dollar signs or a named range). 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Opening multiple Excel files within the same Excel window.
|
lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
| How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode