Excel 2010, 2013 Function HELP!

BajanPaul
BajanPaul used Ask the Experts™
on
Hello Gurus,
I have attached workbook with three tabs.  Matrix, Data and Cure
The data tab needs to pull the data from the Cure tab by area and period.
The Matrix tab need to pull the data from the data tab by area and period.  Simple Vlookups will not get me there..

Any help you could offer is greatly appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
I see no attachment

Author

Commented:
This file did not upload either.. Please find attached.
T2.xlsx
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
please find attached.

i had to use a helper column, becuase you had merged cells.
T2.xlsx
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
First question  i have is what is a helper column.. Can you help with the other function for the data tab.. I am using a single vlookup to pull the data from the Cure tab... I am uploading the excel workbook again for your review.. thanks for your help.
T2_r1.xlsx
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
sorry i meant helper row.  

if you check the "Data" sheet first row. i have puts text there and i used that first row in the formula inside matrix sheet. the reason i used that helper row becuase you had merged cells and i did not touch that instead i used the helper row B1 to J1 and then has changed the font color to white so it is invisible.
Microsoft Excel Expert
Top Expert 2014
Commented:
please find attached.   i have also put the formula in the Data tab to replace your vlookup
T2_r1.xlsx

Author

Commented:
Flawless!! Thanks for your help.
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
You are most welcome

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial