| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup and Calculate Formula
In another post I got an Offset answer, but what I ultimately want to do and
can't seem to get to is: On Sheet YTD, look up Cell A10 (Smith) in the range "Budget", (Smith is found in cell A13 in the range), then calculate this offset for the Row A13 in the range "Budget" =SUM(OFFSET(A13,0,0,1,A1-4)) And change the row number based on the look up. TIA! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function help to lookup and calculate the sum? | Excel Discussion (Misc queries) | |||
| Lookup, Sum or Calculate | Excel Worksheet Functions | |||
| Formula does not calculate - Have tried F9 | Excel Worksheet Functions | |||
| Calculate the average using the Lookup function or similar | Excel Discussion (Misc queries) | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Threaded Mode
