VLOOKUP

[Rubber Beaked Woodpecker]

I have the following customer database:
Column A1:A600 - Customers Name
Column B1:B600 - Customers Address
Column C1:C600 - Customers account number

I would like to a formula so that if a account number is entered into D1 it would lookup the database and enter the customers name into E1 and the customers address into F1.
I believe this would require a VLOOKUP formula but cannot get this to work. This has to be a formula and not VBA.

Any advice please

Thank you RBW

 

[Fluff]

How about in E1 dragged across

=INDEX(A$1:A$600,MATCH($D1,$C$1:$C$600,0))

 

[Rubber Beaked Woodpecker]

How about in E1 dragged across

=INDEX(A$1:A$600,MATCH($D1,$C$1:$C$600,0))

Perfect thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Rubber Beaked Woodpecker]

Anyway of preventing #N/A error from displaying if the account number is not present?

TIA

 

[Fluff]

Yup, like

=IFNA(INDEX(A$1:A$600,MATCH($D1,$C$1:$C$600,0)),"")

 

[Rubber Beaked Woodpecker]

Yup, like

=IFNA(INDEX(A$1:A$600,MATCH($D1,$C$1:$C$600,0)),"")

Fantastic Sir! Thank you

You have saved me god knows how many frustrating hours!!

 

[Fluff]

My pleasure.

 

[austinb]

Yup, like

=IFNA(INDEX(A$1:A$600,MATCH($D1,$C$1:$C$600,0)),"")

Thank you, I never knew about the IFNA function. It will be very helpful in the future.