Hello all
Im trying to make IF rules work with a combination a of lists
Help 1.png
Cell B125 (New Brakedown) + B126 (Handset) + C126 (GSV) are all drop down lists with various options U26 id a formula that adds them all together to create what i want the IF rule to look up.
However its not working im guessing this is because the cell actual equals =B125&" "&B126&" "&" "&C126 and not "New Brakedown Handset GSV"
Is there any way this can be done? I would like people to be able to create there own custom report this way.
Bookmarks