Forum Discussion
Looking for a little direction.
I’m building a data base of clients and want to use their phone numbers as a trigger to populate a daily schedule on a separate sheet. For example: I type in the clients phone number and want their name and address to populate in their respective cells. I’m sure it can be done just not sure just how to go about it.
would really appreciate any advice. Cheers.
jimstevens1966 XLOOKUP() would be best choice.
=XLOOKUP(D5,Clients!C:C,Clients!B:B)INDEX()/MATCH() will also do the same.
=INDEX(Clients!B:B,MATCH(D5,Clients!C:C,0))
