Index/Match Question

Becky Wardlaw

I have a formula need that I hope you all can help with.

I have two sheets that have a unique identifier. What I'd like to have happen is when the identifiers match between the two sheets, then data in one columm in a sheet, populates into a column in a different sheet.

So when the MHID's match between the two sheets, we want the list of deliverables in the top sheet to populate in the bottom sheet. I'm struggling to get the equation to work.

Please help!

Mark.poole

@Becky Wardlaw

Be sure to change the references to match yours.

=Index({Description},Match(MHID@row,{MHID},0))

See how this works out for you.

Mark.poole

@Becky Wardlaw

Be sure to change the references to match yours.

=Index({Description},Match(MHID@row,{MHID},0))

See how this works out for you.

Mark.poole

@Becky Wardlaw

I just re read what it is your wanting. Sadly multi select items can not be done in a formula. You can how ever make it show text values. using HAS functionality. how ever this will be a REALLY long formula depending on how many Deliverables you have in your multi select dropdown.

Becky Wardlaw

Thank you! My thinking was backwards on the formula!!