IFS Range/ Index Range

[Enzo_Matrix]

I have a table with 8 columns and I am trying to create a drop down menu that will return an integer from locums A,C,E,G when I choose text from columns B,D,F,H respectfully.

If I choose:
Text 1 (from column B)
It returns: "1"
If Text 3 (From column D)
Returns: "5"

Is there a way to use IFS() with a Range() and multiple criteria?

 

[Enzo_Matrix]

Re: IFS Range/ Index Range help

To make things a little clearer,

I am trying to have this code be active for an entire column B and have the value in C change 1:12

=IF($A$1=$B1,"1","")

This can be done in either VBA or in the cell directly. VBA preferred.

 

[Learn Excel in Tamil]

Re: IFS Range/ Index Range help

Sub Test()
If ActiveCell.Address = "$B$1" Then
MsgBox "1"
End If
End Sub

 

[Enzo_Matrix]

Re: IFS Range/ Index Range help

More clarification.

I am trying to get this code to work and I know this code is not right but I do not know what to exchange it with.

=IF(S9=$N6:$N17,$M6:$M17,"")

Please help