#INCORRECT ARGUMENT SET

mlourido

hI Hi team,

I have following formula:

=IF(VLOOKUP(Notes@row, {Order}, 6, false) <> "", VLOOKUP(Notes@row, {Order}, 6, false), VLOOKUP(Notes@row, {Order}, 5, false))

it work perfect in one Worksheet, but when I copy it to a new workseeht it shows #INCORRECT ARGUMENT SET.

Please some clue to solve it

Kelly Moore

Hey @mlourido

When you copied the formula into the new sheet, did you create the {Order} cross sheet reference for the new sheet? If not, delete one of the instances of {Order} out of the formula then, using the Reference Another Sheet link in the formula window, create the reference. Be sure to name this range Order, as an exact match to the existing reference.

Kelly

Kelly Moore

Hey @mlourido

When you copied the formula into the new sheet, did you create the {Order} cross sheet reference for the new sheet? If not, delete one of the instances of {Order} out of the formula then, using the Reference Another Sheet link in the formula window, create the reference. Be sure to name this range Order, as an exact match to the existing reference.

Kelly

mlourido

Thank you Kelly for your prompt answer.

It did work