Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
HI,
I'm trying to work out a formula that will bring back data from a table as below 1 2 3 4 5 60 20 10 6 40 5 61 1 25 70 45 12 62 7 70 20 52 10 I need a formula that would compare the x & y axis of the table when given the values and report back the associated cross value. I was thinking along the lines of a vlookup and h lookup in combination with an IF statement somehow. Or is there a specific formula within excel? Many thanks -- Adam&ellie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup and hlookup in the same formula | Excel Discussion (Misc queries) | |||
Hlookup, Vlookup and IF in combination?? | Excel Discussion (Misc queries) | |||
Combination of Vlookup & Hlookup | Excel Discussion (Misc queries) | |||
can hlookup and vlookup be used in combination ? | Excel Discussion (Misc queries) | |||
SUMIF - HLOOKUP Combination | Excel Worksheet Functions |