Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A1 A2 A3
1 3 4 2 5 6 3 6 3 4 7 8 5 3 2 6 2 1 7 3 9 I am trying to find a combination formula that looks at column A2 for a specific value from another cell (say the cell value is 3 in this case). If column A2 though contains the value "3" as this examples shows, I want to look at column A3 just for the rows containing "3" in column A2 and return the value found in column A1 for the largest value found in A3 for that same row. I hope this makes sense. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP Condition | Excel Discussion (Misc queries) | |||
two condition for vlookup? | Excel Worksheet Functions | |||
2 condition vlookup | Excel Discussion (Misc queries) | |||
VLOOKUP used only when IF condition is met | Excel Worksheet Functions | |||
vlookup in two condition | Excel Discussion (Misc queries) |