IFS statement with Data Validation

[chasechap]

Hello,
I am trying to make an ifs statement that works with data validation.
I want it to be
IFS(A1="Location1","Fred",A1="Location2","Mike",A1="Location3", *drop down of 3 names*)
(If A1= Location 1 then A2 autopopulates to Fred, same with location 2 and Mike, Location 3 I want a drop down of 3 names in A2)

Any ideas on how it would be able to work?
Thanks!

 

[theBardd]

Data Validation doesn't auto-populate, it just checks that the input is valid, or provides a list to select from.

 

[tyija1995]

You'll need to use VBA for this I think, try this worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
    Range("A2").Validation.Delete
    If Range("A1").Value = "Location1" Then
        Range("A2").Value = "Fred"
    ElseIf Range("A1").Value = "Location2" Then
        Range("A2").Value = "Mike"
    ElseIf Range("A1").Value = "Location3" Then
    With Range("A2").Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:="=nameList"
        .IgnoreBlank = True
        .InCellDropdown = True
        .ShowInput = True
        .ShowError = True
    End With
    End If
End Sub

Where nameList is a named range containing the 3 names for the drop down.