In d31 i have an if function
IF(D24<=4,"4",IF(D24<=6,"6",IF(D24<=8,"8")))

so that returns the size of the carpet now if i use that function in
d31 and have the
=INDEX(A73:D84,MATCH(D30,A73:A84,0),MATCH(D31,A73: D73,0)) in cell d32 it
doesnt work

if i simply type in a 4 or 6 or 8 it does but part of my qustion is to
automaticaly have the 4 6 or 8 calculated... any ideas.





Lars-Åke Aspelin;219918 Wrote:
On Sun, 8 Feb 2009 22:15:00 +0000, gini76
wrote:


Hi Guys

I have a table

Carpet m2 4 6 8
Golden Berber Twist 22.99 26.99 28.99
Eco Blue 14.99 18.99 21.99
Royal Crown 19.99 21.99 24.99
Southern Stripes 12.99 14.99 18.99
Black Widow 18.99 20.99 22.99
Play Town 19.99 21.99 24.99
Royal Keshan 14.99 18.99 21.99
Motet Grey 14.99 18.99 22.99
weave crown 21.99 24.99 26.99
Wild Flower 19.99 21.99 23.99
Classic Floral 26.99 28.99 34.99

The table starts in A73 and goes down to A84 as i need to have it all
on the same sheet just hidden.

In cell d30 i have the name of a carpet for example Motet Grey
In cell D31 i have the size roll needed for example 4
in cell D32 i want the price of the roll to show up automatically

Any Ideas?

Thanks

Gina
x


Try this formula in cell D32:

=INDEX(A73:D84,MATCH(D30,A73:A84,0),MATCH(D31,A73: D73,0))

Hope this helps / Lars-Åke


--
gini76
------------------------------------------------------------------------
gini76's Profile: http://www.thecodecage.com/forumz/member.php?userid=118
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60469