How to Show name to corresponding account number.

Basic Excel user here. This question is probably very simple.
I need a formula to show a customer's name when user types in account number.

We have been using the find function to locate but this is confusing some newer staff and time consuming.

I have gotten myself confused by complicated online examples of IF and IFERROR and VLOOKUP

My layout is very simple,
A1 is blank and is where user will enter in the account number needed to be matched to customer name.
A2 is where we want name to auto fill
Column B is customer name list B1:B1000
Column C is corresponding account numbers C1:C1000

Any help is appreciated.

Maybe something like this?

=index(C1:C1000,match(A1,B1:b1000,0))

If you want it "empty" until you enter an account number...
=if(A1="","",index(b1:b1000,match(A1,c1:c1000,0)))

Originally Posted by sudbhavani

Dear MowersMike

You can use the VLOOKUP function in Excel to achieve this. Assuming that you want to input an account number in cell A1 and auto-fill the corresponding customer name in cell A2, you can use the following formula
In cell A2, enter the following formula:

Formula:

Please Login or Register  to view this content.

A simple vlookup wont work, because the count number - which is your search criteria - is to the right of what you want to return.

Happy to help, thanks for the feedback