Using Contains If formula

vishalpandey

Hello Community,
I have a form which can be filled by different fellows.
These fellows fill out the form to submit their budget of $ that they have used for different purposes.

I am copying the entry from the Master sheet to the respective fellow sheets using automation.
Now these sheets have fellow 1 to fellow 20 columns.
I want to copy the amount that is being shared to a specific column if the name of the Fellow the sheet belongs to appears in any of the fellow columns

I am using
=IF(CONTAINS("507737 - Rachel Hawley", [Fellow 1 BIN]@row, [Fellow 1 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 2 BIN]@row, [Fellow 2 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 3 BIN]@row, [Fellow 3 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 4 Bin]@row, [Fellow 4 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 5 BIN]@row, [Fellow 5 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 6 BIN]@row, [Fellow 6 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 7 BIN]@row, [Fellow 7 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 8 BIN]@row, [Fellow 8 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 9 BIN]@row, [Fellow 9 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 10 BIN]@row, [Fellow 10 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 11 BIN]@row, [Fellow 11 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 12 BIN]@row, [Fellow 12 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 13 BIN]@row, [Fellow 13 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 14 BIN]@row, [Fellow 14 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 15 BIN]@row, [Fellow 15 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 16 BIN]@row, [Fellow 16 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 17 BIN]@row, [Fellow 17 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 18 BIN]@row, [Fellow 18 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 19 BIN]@row, [Fellow 19 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 20 BIN]@row, [Fellow 20 $ Share]@row, "Enter Amount"))))))))))))))))))))))))))))))))))))))))

The above formula.
It is giving me an incorrect argument.
What am I doing wrong here?
Any help will be appreciated.

Thanks

heyjay

Can you try wrapping your CONTAINS formula in parenthesis,