You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Need help in Number


Hello everyone, I have reservation system! But I stuck in here I cannot think of anything to move on!


as you see in the left table its the customer information, and the right table used for arranging the drivers program.


the question is” there is a way that i have to right only the id in the right table and the rest of information (phone number to area) written automatically?


iPad Pro 12.9-inch, 3rd Gen, Wi-Fi, Cell

Posted on Mar 22, 2022 3:30 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 22, 2022 6:54 AM

You can use XLOOKUP, something like this:




The formula in B2 of Table 2, filled right, is:


=XLOOKUP($A2,Customer Info::$A,Customer Info::B,"")



SG

3 replies

Need help in Number

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.