Apple launches Apple Store app in India
The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >
The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >
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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Here is an example of what I am needing.
Sheet 1
Sheet 2:
Column A I need to call the name from Sheet 1: Column A to match the number in Sheet 2: Column B (Ignore Flow-A, B, C), just need it to look at the number and match the number in Sheet 1 and pull the name over from sheet 1 to sheet 2.
If you can help me with a formula for this, that'd be great.
Thanks!
[Re-Titled by Moderator]
If the codes in the first table are Text (left-aligned by default but you may have changed the alignment manually) then you can do something like this:
In A2, filled down:
=XLOOKUP(TEXTBEFORE(C2,"-"),Table 1::B,Table 1::A,"not found")
If you got those leading 0s in the Code column by applying the 'Numeral System' Data Format with 4 places, then you can do this:
=XLOOKUP(VALUE(TEXTBEFORE(C1,"-")),Table 1::F,Table 1::A,"not found")
Use ; instead of , in the formula if your region uses , as the decimal separator.
For future reference note that those are tables in Numbers, not sheets. A sheet in Numbers does not have cells. It is a blank canvas on which you can place multiple tables, charts, text boxes, and other objects.
More on the functions used here:
SG
Formula for matching names and numbers between two sheets in Number
