February 23, 2026•1 min read•from 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.

Our take

Navigating price lists can be frustrating, especially when you need to find the right price based on specific dimensions like width and length. Imagine a streamlined approach where you input both measurements and instantly see the intersecting price cell. By combining XLOOKUP functions, you can create a dynamic formula that pulls the relevant price without the hassle.

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]

Read on the original site

Open the publisher's page for the full experience

View original article →

Lookup in table, return a formulaIs there a way to lookup a name/value of a cell in a table and the resulting answer is a formula? I am wanting to build a calculation, which could use 1 or more variables, depending on the value of a dropdown menu (Im assuming a drop down, since that would force the exact name/format of the formula callout). https://preview.redd.it/bhib489h9fpg1.png?width=1115&format=png&auto=webp&s=c79605dbb3388ec2e3471e60aecb4dd1f304bcfd Above is a quick and dirty example. If in Cell8, there is a drop down that listed the values in column J (1 Face Area, Length Face Area, etc.). In Cells D-F8, a user can input the thickness, length & width. Cell H8 would lookup the value from C8, reference the table from J5:K11, and after finding the formula, it will do the appropriate calculation. What I listed as a formula is just text for the example. I am open to adjusting as needed. This is just an example. I know I could do a bunch of imbedded IF statements in this example, but assume the table from J5:K11, could be many many lines. The table could be as many columns and rows as needed. Further, the example is just a single line (row 8), the intent would be to have many (10's, 100's or even 1,000's) rows of data, so calculating the answers and looking those up the table wouldn't work, like a single line entry. Is this even possible? I would prefer to accomplish this without VBA, if possible. EDIT: Here is another version of the example. As you can see I am planning on having multiple lines of entries. Some will have the same dropdown formula requested (i.e. Length Face Area), while others may never be requested. Hopefully that clarifies a bit. Also, while I would prefer to do without VBA, if that is the "easiest" solution, I am not opposed to entertaining. https://preview.redd.it/kqil9xiljfpg1.png?width=759&format=png&auto=webp&s=71f6d68f69bd0f6a5550d256b344032d7bc9ccbb submitted by /u/ernstm63 [link] [comments]

Tagged with

#rows.com

Need a formula to find intersecting price cell based on two user input variable values width and length) if possible.

Related Articles

Tagged with