Hi there,
I looked at the "multiple IF" post by Paul earlier today in this sub-forum, but I don't understand it.
I've written many formulas before for a spreadsheet, but nothing as detailed as the one I'm trying to write now. Please see the attached worksheet and if you have any more questions, please let me know...and thanks for your help!
The Formula I am trying to write is the example below -
If B3 is the name JAKE, then C3 is 16.63; If B3 is the name JARED then C3 is 17.78;
If B3 is the name KEITH, then C3 is 14.40; If B3 is the name MATT, then C3 is 14.40;
If B3 is the name SANDY, then C3 is 14.40; If B3 is the name TIM then C3 is 25.00;
so on and so forth, all the way down the B & C columns.
The list of names and their rates are on sheet 2. I want to type the name in B and I would like C to auto-fill, type the hours in D and E
would also auto-fill. The way it is written now, if I change the name (i.e. from MATT to JAKE) the wrong rate is in column C.
Do I need to do an "array", I don't know much about them. I need to implement this formula at work in the next few days.
P.S. I use Excel 2003 at home and Excel 2007 at work, if that makes a difference in the written formulas.
Bookmarks