formula query

[brianaclark1967]

Hi Guys,

I'm looking to string 4 if statements together.

You'll see on the attached sheet that A3 has a drop down menu with four choices in it.

Each choice needs a different result in cell B3

Hope you can help guys.

Regards.

Brian

 

[MohanBabu1023]

Hi Brian,

This formula, u looking for

 

[brianaclark1967]

Hi Brian,

This formula, u looking for

Thank you so much.

That is perfect. I really appreciate your help.

Regards.

Brian

 

[bobhc]

You could have used dependent data validation.


http://www.contextures.com/xlDataVal02.html



.

 

[Somendra Misra]

Hi,

Just another option using VLOOKUP.

Regards,