Index Match

[Stclements1]

I wanted to do an index match for my problem but I have too many criteria and then thought maybe a nested if statement but again wasn't sure so would be very happy for some guidance.

I need to the evaluate the value in cell B7 based on cell values in B2,B3, but these values differ pending on each one
Cell B2 = 10000
Cell B3 = an array cells E1:E3 whose values are respectively 1,2,3 (these numbers also relate to another array F1:F3 1=10, 2=22, 3=34


Example
if cell b3 = 1 then cell b7 =b2/10
if cell b3 = 2 then cell b7 =b2/22
if cell b3 =3 then cell b7 =b2/34

 

[gaz_chops]

Maybe

=B2/CHOOSE(B3,10,22,34)

or

=B2/CHOOSE(B3,F1,F2,F3)

 

[gaz_chops]

or

=B2/LOOKUP(B3,E1:F3)

 

[Stclements1]

Many thanks for your help. I tried all three and =B2/CHOOSE(B3,F1,F2,F3) worked perfectly.

Thank you.

 

[gaz_chops]

You're welcome, thanks for the feedback.