Automatic price calculation

[misspancake]

Hi, does anyone knows how can I calculate multiple prices automaticly, based on different measurements?

 

[etaf]

index($D$13:$D$1000, match(A4&B4&C4, $B$13:$B$1000 & $C$13:$C$1000 & $A$13:$A$1000 , 0))

 

[misspancake]

index($D$13:$D$1000, match(A4&B4&C4, $B$13:$B$1000 & $C$13:$C$1000 & $A$13:$A$1000 , 0))

thanks, but it says that there is a mistake in the formula and I cant understand the problem

 

[etaf]

works ok for me

Book2
	A	B	C	D	E
1
2
3	H	W	D
4	710	300	350		25
5
6
7
8
9
10
11
12	D	H	W	price
13	300	720	350
14	300	720	400
15	350	710	300	25
16	350	720	350	12
17	350	720	400
18	350	720	500
19	350	720	600
20
Sheet1

Cell Formulas
Range	Formula
E4	E4	=INDEX($D$13:$D$1000, MATCH(A4&B4&C4, $B$13:$B$1000 & $C$13:$C$1000 & $A$13:$A$1000, 0))

 

[misspancake]

works ok for me

Book2
	A	B	C	D	E
1
2
3	H	W	D
4	710	300	350		25
5
6
7
8
9
10
11
12	D	H	W	price
13	300	720	350
14	300	720	400
15	350	710	300	25
16	350	720	350	12
17	350	720	400
18	350	720	500
19	350	720	600
20
Sheet1

Cell Formulas
Range	Formula
E4	E4	=INDEX($D$13:$D$1000, MATCH(A4&B4&C4, $B$13:$B$1000 & $C$13:$C$1000 & $A$13:$A$1000, 0))

sorry I am noob in excel and it is confusing me. E4 counts automaticly based on materials etc with given measurements in A4,B4 and C4. I need to calculate 2000 prices with different measuremnts in price collum from D13. I need excel to put all those measurents for me in my price counting table and write a price. is that what this formula does? thank you for your time

 

[etaf]

No,
I may not have understood what you want
I thought
you had a list of sizes , H,W,D with a price from row13
and you wanted to enter in
A4,B4,C4 - the size and for that to be looked up in A13,B14,C14 columns and find those measurements that match all 3 and return the price
as my example show

E4 counts automaticly based on materials etc with given measurements in A4,B4 and C4.

Not sure what that Means - E3 title is unfixed Shelf number and in E4 is zero

I need excel to put all those measurents for me in my price counting table and write a price.

Not sure i follow or know how to do what you are after
Also its duplicated from ROW 26

for other members can you explain how those sizes are derived ..... as i cannot follow what you need now - sorry