View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
adam&ellie adam&ellie is offline
external usenet poster
 
Posts: 4
Default Formula help - possible vlookup/hlookup combination with IF or oth

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