In columns X and Y of Sheet X, I have a list of names and numbers:

James, Lebron 82
O'Neal, Shaquille 80
Wade, Dwyane 79
Duncan, Tim 72

In column B of Sheet B the same names are listed in a different order with
firstname first:

Shaquille O'Neal
LeBron James
Tim Duncan
Dwyane Wade

In column C of Sheet B, I want to enter a formula that references the names
in Sheet X and returns the corresponding number for each name (ex: O'Neal =
80; Wade = 79, etc.)

Can anyone help?

Thanks,
Bob


What is the formula to do that?

thanks,
Bob