Hello @JRad

Let's try this. It looks like you might be missing a closing ")" for the IF function and add the ",0" to the match functions to specify an exact match must be found.

=IF(INDEX({1st_Budget}, MATCH([Row ID]@row, {Row_ID},0)) = “Philadelphia”, INDEX({1st Budget Amount Approved}, MATCH([Row ID]@row, {Row_ID},0)), INDEX({2nd Budget Amount Approved}, MATCH([Row ID]@row, {Row_ID},0)))

If the Row ID occurs multiple times in your list, I recommend using the COLLECT function to add another criteria and simplify the results. Otherwise the first match found will be the result for all of the reoccurring Row ID's.

The problem is your quotes around "Philadelphia". Notice how mine are straight up and down and yours are slanted? Yours are called "smart quotes" which (ironically enough) are not recognized as valid characters in Smartsheet formulas.

Try retyping in your sheet directly, here in the Community, or in a text editor such as Notepad (not Word).

Happy to help. 👍️