#incorrect Argument set

Yvette Scherer

I am trying to write an index formula and I keep getting #incorrect argument set. I am trying to reference data on one sheet and return the information from another sheet.

Andrée Starå

Hi @Yvette Scherer

I hope you're well and safe!

Can you share some screenshots and paste the formula you're testing? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Yvette Scherer

Here is the formula

Product mapping is the other sheet I am trying to reference

Andrée Starå

@Yvette Scherer

Try this.

=INDEX({Product Mapping Range 1}, MATCH([Product ID]@row, {Product Mapping Range 2},0)

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Yvette Scherer

No it still is not working

Andrée Starå

@Yvette Scherer

Did you create the ranges for the other sheet?

Yvette Scherer

Yes, I am working on building 2024 things and I copied over files from 2023 but some of the formulas are not working. I looked back at 2023 formulas and they look the same as how I built 2024 in this new sheet. There were no additional columns added

Andrée Starå

@Yvette Scherer

Can you take a screenshot of the Sheet Reference Manager?

Yvette Scherer

I re wrote the formula and now I am getting a #no match error.

Below is the formula

Andrée Starå

@Yvette Scherer

Excellent! Then it works!

What are the different ranges referencing?

Yvette Scherer

below is the sheet I am referencing, the 2 blue columns are what I am looking at:

Below is how it should read if the formula was working

Yvette Scherer

Hello,

The formula still reads #No Match, but I can see that there is a match on the sheet that I am referencing. Is there something else I should look at?

Andrée Starå

@Yvette Scherer

What do you see if you double-click the cell in the Source sheet?

I suspect it's a mismatch between text and numbers.

Can you share more screenshots of the Source and Destination?

Yvette Scherer

I was thinking it could be a mismatch between text and numbers, but the formula works in my excel. I can see in the source sheet that the columns are linked to the sheet that I want. And both columns are set up as text/number

Here is the formula I have with the error. I am looking at product line. I have the same error in the Channel column.

The two blue columns are the one's I am linking to