misspancake
New Member
- Joined
- Mar 2, 2024
- Messages
- 3
- Office Version
- 2021
- Platform
- Windows
thanks, but it says that there is a mistake in the formula and I cant understand the problemindex($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 timeworks 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))
Not sure what that Means - E3 title is unfixed Shelf number and in E4 is zeroE4 counts automaticly based on materials etc with given measurements in A4,B4 and C4.
Not sure i follow or know how to do what you are afterI need excel to put all those measurents for me in my price counting table and write a price.