Match index formula

Hi,

In the attached spreadsheet i need some match index formula in tab "Pnl" which is looking up tab "Data_Tab"

I need the totals for each weekending (i have manually entered some for guidance)

In row 11 i have put the names of the columns the totals need to match against

Can someone provide the formula so these numbers will fall out in the pnl tab

Thanks!
Seamus
HOWL-REPORT.xlsx
Seamus2626Asked:
Who is Participating?
 
ShumsDistinguished Expert - 2017Commented:
Hi,

Check in attached...
Seamus2626_HOWL_REPORT-2.xlsx
1
 
NorieVBA ExpertCommented:
Seamus

Where do the values in B1 & B2 on PnL derive from?

There aren't columns named Total Revenue or Cost of Purchases so I can only assume they are a sum of some sort, but what of isn't really clear.
0
 
Seamus2626Author Commented:
Hi Norie, i had just summed the data tab as an example of what i wanted the sumifs to do, thanks
0
 
Seamus2626Author Commented:
Thanks Shums!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.