IFS, ANDS HELP

Question

Hello and Thanks in advance for any efforts or insights to my excel problem, I have been searching for 2 weeks for a solution to this issue, I used ALOT &nbsp;of nested "if" functions that seemed to sort of work out but I could only use one column (A or B) and need both columns to be true for the results in columns C &amp; D to populate correctly. &nbsp;The other issue is that Column A and B is data that is selected from a drop down selection of a LIST I created. &nbsp;So,&nbsp;I have a couple of LISTS I use in my excel spreadsheet that I created as drop down selections in two different columns. &nbsp;After these two columns data have been selected from the drop down list items, then I need two other columns to populate a number value. &nbsp;Here is an example:(PERSON), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (JOBSITE NAME), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (RATE), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (BILLED RATE)COLUMN A, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COLUMN B, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COLUMN C, &nbsp; &nbsp; &nbsp; &nbsp; COLUMN DJOE (OR?) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RAMS (OR?) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;52 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;57&nbsp;(OR A SELECTION OF OTHER PERSONS SELECTED FROM A DROP DOWN LIST IN COLUMN A, AND A&nbsp;SELECTION OF OTHER JOBSITES SELECTED FROM A DROP DOWN LIST FROM COLUMN B), WILL GIVE OUTCOMES IN RATES FOR COLUMNS "C" AND "D")&nbsp;

philip west · Answer

Hia,I wouldn't post your phone number publicly here.. who knows where it will end up.&nbsp;I'll have a look at the spreadsheet you posted today and get back to you.

philip west · Answer

Hia,I've had a look at the spreadsheet that you attached and 'fixed it' for you :)&nbsp;I've written a few notes on there that hopefully point you in the right direction as far as understanding the formulas. You should find it pretty flexible as far as adding or removing people and jobs goes, just watch out for the column headings of the rate table, they must match exactly the name of the job.

michon rieben · Answer

Phillip,This is so helpful and I really appreciate the time you have spent trying to help me, and I also appreciate the "teaching" insight and instructions you have included with the spreadsheet you sent to me.Lord Bless Ya Bunches, I would not have been able to do this without your help!!!!!!!!!!

philip west · Answer

No worries. Glad it worked for you.&nbsp;Good luck with your project. Philip

philip west · Answer

Can you have a table of names/jobs/rates/billed rates to look up against?

If you can, you could use an 'index match match' to check find the details you are looking for.

I've attached a copy of it working, I think this is what you are trying to do. If it is and you need more of an explanation how let me know.

Forum Discussion

IFS, ANDS HELP

Share

Resources