Junk

Ask something
Question Locked

problem using data validation and vlookup; using 2 inputs to get 1 value

0 helpful
2 replies

by johnmotson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Basically i have 2 drop down menus with slope and Rmax in each. In Rmax there is the option of Rmax37 and Rmax99.

What I need is a a function where i select say "slope 1 in 1 and Rmax37" the value for coefficient A=0.00703 pops in a cell, the same for Rmax99 where if i select 1 in 1 and Rmax99 0.00515 appears in the cell.
i would like the same for the cofficient B.

I have a table as such below

Slope Rmax37 Rmax99

1 in 1 A 0.00703 0.00515
B 3.42 6.06

1 in 2 A 0.00753 0.00542
B 4.17 7.16

1 in 3 A 0.0104 0.00922
B 6.27 10.96

2 replies

by absolutely

I'm sure not going to write you one, but I'll tell you that if I understand what you've said, you want a calculation to be based on what value is selected from a drop-down control, and that sounds like you need to use VBA. Have "fun" with that!

This discussion is closed to new replies.