I need help with my MATCH formula, I am getting a syntax error. See screen shot below, and formula

June Dodson

Carson Penticuff

You forgot to include "@row" when referencing the social security# column.

June Dodson

June Dodson

I am getting a circular reference when I add your suggession

heyjay

https://community.smartsheet.com/discussion/116289/i-need-help-with-my-match-formula-i-am-getting-a-syntax-error-see-screen-shot-below-and-formula

=index({employee name 2},
match([employee id#],{ss # range 1},0)
)

The [Social Security #] is not needed. That is where you are making the fomula, right?

Lucas Rayala

@June Dodson If you are trying to return the social security number, you aren’t structuring this correctly. Please review the below help articles for INDEX and MATCH.

Generically, your function needs to look like this:

=INDEX ({info you want from reference sheet}, MATCH (UniqueId@row, {unique id on reference sheet}, 0))

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match