New to excel if formula question

[Deleted]

It's been a few years since I last used formulas in excel and I have a spreadsheet that I want it to automatically output a name if it reads a certain data set.  Like for my spreadsheet, I want to automatically assign an employees name based off of what state the property is located in. Any help would be appreciated  Thank you.

[#2]

@Deleted 

Let's say you have a sheet named State List.

It contains the names of states in A2:A53 and the names of the associated employee in B2:B53.

On another sheet, you enter the name of a state in - for example - D2.

In another cell in the same row, enter the formula

=XLOOKUP(D2, 'State List'!$A$2:$A$53, 'State List'!$B$2:$B$53, "")

This can be filled down.