IF formula using a range

[Rellsunn]

Hi
Looking for help on a formula that reviews a range of dropped styles on one tab against a list of styles on another and adds a "D" if the styles matches.

I started with =IF(MENS!B:B=DROPPED!A9,"D","-") but this is not working? Range B:B is concatenating the style/color and A9 is just one cell formulated the same way via concatenating style /color but for dropped styles.


So if style/color A is found in B:B then mark cell with "D" if not "-".

Hope this makes sense

Thx

[ConneXionLost]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. Please continue in your other thread.

Thread to be closed by Moderator.

[Rellsunn]

Yes sorry...how do you delete this though?

[ConneXionLost]

You don't. A Mod will eventually delete it for you.