Lookup / If formula

  • Thread starter Thread starter Graeme
  • Start date Start date
G

Graeme

I have a table with column headers that represent the
upper level of a band, eg column 1 10,000, col 2 25,000
etc.

The rows represent different categories.

The table contents is %values.

I want to use a formula that will look at a value (value
1) against the column headers and another value (value 2)
against the row headers so that it can derive the correct
% to increase value 1 by.

Can anyone help?
 
Graeme,

With Value 1 in cell X1 and Value 2 in cell X2, and your table in A1:J100:

=INDEX($A$1:$J$100,MATCH(X1,$1:$1,FALSE),MATCH(X2,$A:$A,FALSE))

HTH,
Bernie
MS Excel MVP
 
Hi
if you could change the column headings to the lower level you could
use the formula
=INDEX(A1:G10,MATCH(value2,A1:A10,0),MATCH(value1,A1:G1,1))
 
Back
Top