| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup formulas
I have 2 spread sheets:
Weeknr Code amount 4 2001 80.00 4 2002 90.00 5 2001 100.00 5 2003 10.00 2ndt sheet A B C 1. Week nr 2001 2002 2. 4 3. 4 4. 4 I want to insert a formula in B2:C4 the amount in spreadsheet 1 if code is equal to B1and C1 and week nr is equal to A2-A4. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Using SumIF formulas with multiple lookup values | Excel Worksheet Functions | |||
| How do I highlight all lookup formulas in a worksheet in one shot. | Excel Discussion (Misc queries) | |||
| Lookup last in column formulas | Excel Discussion (Misc queries) | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
