Need a formula to find intersecting price cell based on two user input variable values width and length) if possible.
This is for a pricelist and the idea is for a salesperson can input a measurement for width and length and the price cell of the intersecting width and length to display:
Row (Width) × Column (Length)=Table body is price
Not sure if it is possible but I'm looking for a way to combine the following two formulas to produce one result from a user inputting variable inputs for BOTH width and length to pull and show the proper intersecting price cell:
For a user variable Width input but Length has to be an established length value in table:
XLOOKUP(Y17,C15:T15,XLOOKUP(Z17,B16:B27,C16:T27),,1)
For a user variable Length input but Width has to be an established width value in table:
XLOOKUP(Z17,B16:B27,XLOOKUP(Y17,C15:T15,C16:T27),,1)
Again, I'm not sure if its possible to combine these two formulas into one but any advice/tips is much appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site