Need help with an excel forumala, trying to avoid macros.
I would be using this formula on cell B1.
Formula required example: If A1 = 1, Populate B1 "Monkey", If A1 = 2, Populate B1 "Bird", If A1 = 3, Populate B1 "Dog", If A1 = 4, Populate B1 "Cat".
Thanks in advance!
Steve.
Bookmarks