need help to create vlookup or index/match formale

[gini76]

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 this box !!! any ideas need to match carpet name with size as well.

Any Ideas?

Thanks

Gina
x

 

[Jonmo1]

It's probably because of the Formula in D31. Is it returning a TEXT value number?
Can you post that formula?

 

[gini76]

the formula i am using is this one

<TABLE style="WIDTH: 291pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=387 border=0><COLGROUP><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4256" width=133><COL style="WIDTH: 191pt; mso-width-source: userset; mso-width-alt: 8128" width=254><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl63 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 291pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white; mso-ignore: colspan" width=387 colSpan=2 height=19>IF(D24<=4,"4",IF(D24<=6,"6",IF(D24<=8,"8")))</TD></TR></TBODY></TABLE>

 

[Jonmo1]

Remove the quotes around the numbers.

That can also be replaced with a simpler lookup type of formula.

How many ranges are there that need to be compared against?

 

[gini76]

ranges?

 

[gini76]

seems to work when i dont use the commas ! thanks ill let you know if i have any problems