| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up table
Try in C1 sheet 1 =LOOKUP(2,1/((Sheet2!A1:A99=A1)*(Sheet2!B1:B99=B1)),Sheet2!C1: C99) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=555973 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to import a table on a Web page to Excel? | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
