Compare two columns and get info from a third?

[sundodger]

Hi All,
I have two lists of customers.
One is a list of target customers with Names in column B and Target type in column A. e.g A, B or C
In the second Sheet it is a list of all customers in the country. with names in Column A
I am trying to get the Target type added into Column B of the second sheet if the name matches one of the customers names in the First sheet.

Any help appreciated.
Thanks

 

[DanteAmor]

Assuming that your name on sheet2 is in cell A2, put the following formula in B2

=IFERROR(INDEX(sheet1!$A$1:$A$10,MATCH(A2,sheet1!$B$1:$B$10,0)),"Name does not exist")

 

[sundodger]

That worked perfectly.
Thank you for your help.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.