Forum Discussion
jimstevens1966
Oct 07, 2024Copper Contributor
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 n...
Harun24HR
Oct 07, 2024Silver Contributor
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))