INDEX MATCH Formula Problems PROBLEM SOLVED

CentricKerry

Hello,

I'm new to Smartsheets and not sure if INDEX MATCH is the correct formula.

I am trying to auto-populate the System ID based on the answer in System Name from a reference table in another sheet. I get an UNPARSEABLE error with the following formula in System ID column:

=INDEX({Leak Details 2023 Reference Tables Range 1}, MATCH({Leak Details 2023 Reference Tables Range 3}@row, [System Name]@row, 0))

Main working sheet

Separate sheet with multiple tables

I will be using the same type of "identification" for other columns in the main sheet as well. Your help is greatly appreciated!

Thank you,

Kerry

CentricKerry

I figured it out!! I had two or the ranges switched.

Ryan Sides

Glad you got it worked out!