I'm trying to improve a simple excel program at work where I have to select an alpha numeric option from a drop-down box, A1, A2, A3 etc.
I want to use a simple if statement eg. =if(C3=A1, 456,0)
Where C3 is in reference to the cell location, and A1 is the drop down option. Is this possible?
FYI, I can't change the drop down options.
Thanks
Bookmarks