0
In excel, I need to show on a "summary" tab the payments that should be made Friday by Friday. I have this information on another tab, where you can find a list of names of whom we should pay and right next a table the amount we should pay each person week by week. (not all the people are paid weekly). I need to display:
- the total amount I should pay each Friday (I know how to do this)
- A list that appears as I input a date on the "summary" tab which shows whom should I pay to that Friday, and how much should I pay each person. This should change as I change the date. -I've tried to do a lookup with a IF function.
Roxana
Posted 2017-06-06T13:46:10.980
Reputation: 1
1I understand what you want. I suggest you have a go yourself. I have no idea what you've tried. And we're not here to do your work for you. As such I'm voting to close. However, please do edit your question to show us what youv'e tried and I can remove my close vote :) – Dave – 2017-06-06T13:52:54.843
"I've tried to do a lookup with a IF function." - that still doesn't clarify your problem:(. Please add some sample data, with desired output, and also the formula you've tried (with description where exactly it failed). – Máté Juhász – 2017-06-06T14:54:26.960