Hey all!
I am not very proficient in Excel since its been maybe three years since I've last touched it for anything other than basic using basic SUM formulas for personal stuff.
Right now at work I have to do a manager a favour and I want to make a worksheet to calculate the sales our team make every month.
I am stuck on the page I want to have three drop down where info will vary depending on the choices made in the first and second drop down.
The first drop down are rep names, the second drop down is the type of transaction made - if the choice is deposit I want special codes to appear and if the choice is offer I want to be able to enter an amount
I know I need to use the IF formula, and the LOOKUP, I really don't remember much but I know I have a lot of fun doing this and I'd love some help with which formulas to use!
Thank you
Bookmarks