Create Combo Box and hide or show based on cell

Occasional Visitor

Good day Everyone, 

 

I want to create a combo box then I want it to appear (show) in B1 when Cell A1 have the letter M in it.

When the letter M is not in A1 I want the combo box to be hidden, and would like to use B1 as normal text

If there is an M in A1 and the box appears in B1 - when I select something I want a to use xlookup in  B2 with the lookup value in the combo box, is this possible?

0 Replies