Join Question

Joe Phelps

Hello All,

I have a sheet referencing two other sheets to pull data and I added another sheet to the mix(2025 Transportation) but I keep getting a INCORRECT ARGUMENT SET?

Any ideas of why this is happening?

New Formula is:

=JOIN([2024 SHIPMENTS]@row, [2025 SHIPMENTS]@row, [2026 SHIPMENTS]@row, CHAR(10))

Thank you!

Janae G.

I assume all the references here are column names in this sheet (not cross-sheet references), correct? If so those should be fine.

I think that JOIN doesn't let you use CHAR(10) as a delimiter. Most of the time delimiters for JOIN are written "," or "/", so I am guessing it it expecting text like that. My test formula also gave me the same error.

This alternative formula should work though:

=[2024 SHIPMENTS]@row + CHAR(10) + [2025 SHIPMENTS]@row + CHAR(10) + [2026 SHIPMENTS]@row

Make sure to have Wrap Text enabled in your sheet so that you can see the line breaks properly.

Melissa Yamada

@Joe Phelps are you joining from adjacent columns?

If so, try this:

=JOIN([2024 SHIPMENTS]@row:[2026 SHIPMENTS]@row, CHAR(10))

If not, you can try this:

=[2024 SHIPMENTS]@row + CHAR(10) + [2025 SHIPMENTS]@row + CHAR(10) + [2026 SHIPMENTS]@row

Joe Phelps

@Janae G. and @Melissa Yamada That formula worked for getting rid of the INCORRECT ARGUMENT SET message on the whole column but it still is not pulling the data from the 2025 SHIPMENT sheet column. Any thoughts on why it wouldnt pull from that sheet?

Each of the reference shipments are columns all labeled the same on 3 different sheets….

Melissa Yamada

@Joe Phelps can you send a sample or screenshots?

Joe Phelps

This is what it should be pulling from for 2025:

This is the formula which is the exact same on the 2024 sheet that is correctly pulling data:

Joe Phelps

This is where the data is being pulled to:

The correct data was pulled from the 2024 sheet(Listed at the bottom row of the above pic). I did a line on the 2025 sheet to test it and it wont pull it for some reason….

Melissa Yamada

What is your formula for the Air/Ground Transportation Shipments? I think it has something to do with that not with your join formula.

Joe Phelps

No error messages….

This is the 2024 Transportation that is pulling correctly onto my sheet:

This is the 2025 that is not pulling correctly onto the sheet:

This is the receiving sheet with the formula you provided:

@Melissa Yamada

Melissa Yamada

Does your 2025 SHIPMENTS column has any formula? Can you share it as well.

Joe Phelps

@Melissa Yamada Yes this is the formula:

Joe Phelps

The "info for REQ sheet" columns on both the 2024 Transportation Spreadsheet and the 2025 Transportation Spreadsheet are each respectively named "2024 SHIPMENTS" and "2025 SHIPMENTS"

Melissa Yamada

The formulas on the screenshots you provided are working as expected.

So we bring it down to the formula that is pulling your 2025 data (2025 Transportation Spreadsheet) to your REQ form which I think is the formula on your 2025 Shipment column right?

Joe Phelps

@Melissa Yamada The idea is for the REQ # to pull the data onto each row on the Req Form sheet based on the number.

So 16842 should pull off the my test row on the 2025 Transportation Spreadsheet.

Melissa Yamada

How are you pulling it from the 2025 Transportation Spreadsheet? Are you using an INDEX/MATCH formula? I think the formula on your REQ Form isn't updated as it is only pulling from your 2024 sheet

Joe Phelps

@Melissa Yamada Yes the formula on the 2025 Transportation Spreadsheet is what should be pulling onto the req form.