#Invalid Data Type in INDEX Formula

andrea lafrania

I am trying to reference a State Abbreviation sheet that has one column the full state name in column 1 and the abbreviation in the column 2. Right now, my form populates the full state name in to my column: "Onsite/Worksite State" and I need it to populate just the abbreviation into a new column. When using the Index formula, I am receiving the error #Invalid Data Type -any help is appreciated on fixing this error

=INDEX([Onsite / Worksite State]@row, {State Abbreviations Range 1}, 2)

Paul Newcome

You need an INDEX/MATCH.

=INDEX({Column You Want To Pull OVer}, MATCH([Column To Match On]@row, {Column To Match In}, 0))