Try the following:

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

Also, what does your IF formula in D31 look like? Does it return a
whole number, or could it be a fractional value that just displays as
a whole number through formatting? Does it return a text value?

Hope this helps.

Pete

On Feb 9, 5:00*pm, 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 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