Hi All,
I trying to work out the formula that would populate a cell with a budgeted amount based on 2 criteria - please can anyone assist? I have attached workbook that has actuals and budget and it is cell AU 4 and5 I need to populate. For ease I have put the budget on same sheet.
Thank you in advance
suzanne
=INDEX($O$12:$AO$14,MATCH($F4,$F$12:$F$14,0),MATCH(AU$2,$O$11:$AO$11,0))
BUT.... The tan-coloured cells F4:F5 and F13:F14 have to match EXACTLY.
Also, in Row 11, the dates are the 1st of the month. In AT2 it was 31st of month. Both now reading 1st. PS I may have changed the name of your file... but it is the right one attached.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you Glenn That is really helpful. I wasted 2 hours at work trying to figure it out with no success! Suzanne
If, by my changes, I have mucked up something else... just shout. Otherwise, you're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks