Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to find a way for excel to do a vlookup (or something like it)
coupled with an hlookup (to obtain a result). Here's an example table: Results Group 1 0.0% 72.0% 74.0% 76.0% 78.0% 80.0% 82.0% 0.0 8.0 10.0 12.0 14.0 16.0 18.0 Group 2 0.0% 74.0% 76.0% 78.0% 80.0% 82.0% 84.0% 0.0 8.0 10.0 12.0 14.0 16.0 18.0 Group 3 0.0% 74.0% 76.0% 78.0% 80.0% 82.0% 84.0% 0.0 8.0 10.0 12.0 14.0 16.0 18.0 In a separate tab, I have the group name (eg. Group 3) and a result value (eg. 78%). I'm trying to create/find a formula that will read the Group name, then read the result, go over to this table (which is on a separate tab) and have it locate Group 3, and do an hlookup for the result of 78 and return me the value of 12. the above table is not a PivotTable. I originally thought I could use a vlookup coupled with an hlookup but I can't get that to work. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can the Row_Index_Num in HLOOKUP adjust relatively? | Excel Worksheet Functions | |||
vlookup and hlookup | Excel Worksheet Functions | |||
Problem with HLookup - Sometimes works, sometimes blank. | Excel Discussion (Misc queries) | |||
Index / Hlookup | Excel Worksheet Functions | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions |