I'm sure this question has been asked, but I can't find the answer anywhere.
I'm trying to create a formula that will auto populate a cell with a specific number if another cell has a certain name. Pretty basic, I think, but I can't for the life of me figure this out:
This is my data
Steve 2201
Paul 2202
Jim 2203
David 2204
Scott 2205
Tony 2206
Josh 2207
So if cell F14 says "Jim", I would like cell J14 to auto populate with 2203. Can someone please help me??
Thanks bunches!!!!
Bookmarks