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

stkatch

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.

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.

Cheers,

Genevieve