Show us your IF formula in cell D31.

--
Biff
Microsoft Excel MVP


"gini76" wrote in message
...

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 but this has been
worked out using an if function.
in cell D32 i want the price of the roll to show up automatically


ive been using
=INDEX(A73:D84,MATCH(D30,A73:A84,0),MATCH(D31,A73: D73,0)) but this only
works if i type in the size roll not if i have an if function in D31 !!!
any ideas

Any Ideas?

Thanks

Gina
x


--
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=60932