Ugh....need help with a cross sheet index/match formula

stkatch ✭✭✭✭
edited 11/15/22 in Formulas and Functions

I have a drop down column titled "SITE", when a SITE is selected, I need the Terminal ID# column to auto populate from another DATABASE sheet for which the SITE column is exactly the same type and title.

=INDEX({SITE Database Range 1}, MATCH([Terminal ID]@row, {SITE Database Range 2}, 0))

Get an UNPARSEABLE error........


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @stkatch

    It looks like you might have your ranges swapped around. 🙂

    An INDEX(MATCH works like this:

    =INDEX({Column with value to return}, MATCH([matching value]@row, {Column with matching value}, 0))

    So in your case, something like:

    =INDEX({SITE Database Terminal ID}, MATCH(SITE@row, {SITE Database Site Column}, 0))

    The names of your ranges may be different, but those are the columns it should be pointing to, does that make sense? See: Formula combinations for cross sheet references

    If this still hasn't helped, it would be useful to see screen captures of both sheets, but please block out sensitive data.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!