1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/najnaj808
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com