This is my first post, and I feel like an idiot that I can't figure this out. But, honestly, I'm gonna have to start drinking if I don't automate this process. I'm trying to get a cell to autofill based on the response in a previous cell. Here's what's up:
SAMPLE DATA SET
A, B
1 Walter Hobbs, 198398
2 Santa Claus, 298737
3 Julie Lemon, 783749
4 Sandy Desert, 783722
/END SAMPLE DATA SET
97 Name | Badge
98 Walter Hobbs | ?
Let's say these are my columns, Name and Badge number. All data is on the same sheet. If the Entry in the A98 "Name" cell equals any one of the entries from the ranged sample data set (remember, on the same sheet) then Badge= corresponding value from sample data set column B.
I hope this makes sense. Thanks for you help, in advance.
Bookmarks