asked on

Choose a value based on two columns

Hi,

Without being with the if function, how can I create a condition to choose a value based on two columns.

For exemple if a giving value is 4,12 for density and 1,87 to volume the value must be 0,0640 €.

best regards

Example in attached image.

Qlemo

The image is missing.

An IF without an IF is not possible. If you can create a formula generating few integers as condition result, choose can be used.
So what exactly do you mean?

Qlemo

If you want to get fancy, a conditional expression can be used, like =(B1 > C1)*50 which generates 50 if B1 is greater than C1 ...

ASKER

Hi,

I have many rows to get a price, with two columns (the price is calculated considering both Density and volume columns, this is a auxiliary table). For each value in Density column i need to verify volume factor to get price.

best regards

Attached image with example

Qlemo

That is something completely different. You need to set up a lookup table with two parameters. With a single one it would be easy (using VLOOKUP with range search), but this one requires something more sophisticated. ~~One way to use a matrix with density as rows and volume as columns, and a nested VLOOKUP and HLOOKUP.~~

ASKER CERTIFIED SOLUTION

Ejgil Hedegaard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rob Henson

You don't need additional columns at all.

See attached file.

Similar to used in this question:Help with Index Match I think
Index-match.xlsx

Rob Henson

Updated version attached showing the Matrix version that I think Qlemo was referring to, using VLOOKUP and MATCH.
Index-match.xlsx