Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup with Variables
This formula needs to be in Col AR
I have tried =LOOKUP(AND(F4,"??? Total"),F4:F720,AI4:AI720) I need to find a cell in Col F that contains the value from the same row followed by the word "Total" and returns the value from Col AI in the same row. (ie. F4 = 108, F7 = 108 Total, AI7 = 7.05) The problem is that I have multiple cells with "??? Total" where "???" is a three digit number relating to the group above it. Can anyone help? ~Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup 2 variables | Excel Discussion (Misc queries) | |||
showing lookup result with multiple variables | Excel Discussion (Misc queries) | |||
can't figure out LOOKUP with 2 variables | Excel Discussion (Misc queries) | |||
Lookup (multiple variables) | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |