Is this possible and if so how do I do it?

Please help

I have a drop down list that has locations and those locations are from a space sheet.

When the location is a certain address there is a director and manager tied to it in that same space sheet. How do I create a formula to connect the sheets so that for each location the director and manager is also pulled for that exact place?

Samuel Mueller

You need a cross sheet reference and probably use an index match formula

=index({Column of Manager name on other sheet}, match([AdressColumn]@row, {Column to Match address on other sheet}, 0))

=index({Column of Director name on other sheet}, match([AdressColumn]@row, {Column to Match address on other sheet}, 0))

Samuel Mueller

You need a cross sheet reference and probably use an index match formula

=index({Column of Manager name on other sheet}, match([AdressColumn]@row, {Column to Match address on other sheet}, 0))

=index({Column of Director name on other sheet}, match([AdressColumn]@row, {Column to Match address on other sheet}, 0))