Formula not pulling correct data

Hi,

I am using this formula to bring back the corresponding data to the Room:

=INDEX({Rooms/Facility/Org Codes FacilityName}, MATCH([Room #]@row, {Rooms/Facility/Org Codes Room#}, 0))

When I select the Room from a dropdown, I select the first A409 and it pulls the 0100 and 0191 appropriately. However, when I use the second A409, it's pulling the same 0100 and 0191 rather than pulling the 2100 or 2181.

Any idea what might be wrong with my formula?

Thank you!

L

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!