I have a list on sheet 1 a1-a100 with names of clients in it. Same sheet,
column B1-B100 i have the phone number.

If in sheet 2, i put the name of the client in one cell, is there a way i
can get the phone number to auto fill in on the next cell in the same sheet?