Formula for matrix.

[rita]

In a matrix similar to this

Fruit Vanilla Chocolate .....
13 £20 £15 £18
12 18 16 15
10 16 14 12
..
..
..

Can you help me with a formula to find the price of a
specific size for a specific flavour please possibly using
vlookup and hlookup?
Rita

 

[Charles Williams]

Hi Rita,

assuming that your matrix is in A14 and that col A is the size and row 1
is the flavour then

=INDEX($A$1:$D$4,MATCH($A$2:$A$4,x1,0),MATCH($B$1:$D$1,x2,0))

where x1 contains size and x 2 contains flavour


Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

In a matrix similar to this

Fruit Vanilla Chocolate .....
13 £20 £15 £18
12 18 16 15
10 16 14 12
..
..
..

Can you help me with a formula to find the price of a
specific size for a specific flavour please possibly using
vlookup and hlookup?
Rita