Forum Discussion
New to excel if formula question
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.
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.
