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
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
A simple way would be to use TEXTAFTER, something like this:
In D2 of the example, filled down:
=TEXTAFTER(C1,"-")
Then if you want to remove the formula from that column, select the cells, command-c to copy, followed by Edit > Paste Formula Results.
More on TEXTAFTER here:
SG
Worked brilliantly! Thanks!
Second question now, if I want to separate the FLOWER A, FLOWER B, FLOWER C from the number and create a column with just that range of text. What formula should I use for that?
Thanks!
That works! Thanks. Spreadsheet completed.
Formula for matching names and numbers between two sheets in Number
