Adjacent Cell Auto Populate Question. Please Help!

I don't know if this is super advanced, but here's what I would like to do.

I have a list of names (e.g. John, Michael, Tom) in one cell and account numbers (e.g. 123, 456, 789) in an adjacent cell. Each account number corresponds to one person. I always enter the account number first.

123 Michael
456 Tom
789 John

Is there any way that I can have the cell adjacent to the account number auto populate with the name after just entering the account number (without having to ever enter the "name" cell)? In other words, I want excel to recognize that the account numbers correspond to each person and auto populate that information.

This would be SUPER helpful! Thank you for any help you can provide!

Hi

You will need to make a list of the details somewhere. For this example we'll say you have a sheet called "ID". On this you have 3 people set out like your example.

123 Michael
456 Tom
789 John

Your your main sheet you will have the ID number in column A while the name will appear in B.

Formula:

Please Login or Register  to view this content.

This looks up the ID number (A2) in the list (A1:B3). Finds the number and moves one cell to the right. The $ signs stops the ranges from getting all messed up when you copy and paste this about.

If there's any more help you need with this then please let me know

Thank you! This is exactly what I need!!

You're welcome