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

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#row zero
#AI formula generation techniques
#cloud-based spreadsheet applications
#price
#width
#length
#XLOOKUP
#intersecting
#formula
#user input
#cell
#pricelist
#salesperson
#measurement
#table