scottmcclean
New Member
- Joined
- Jul 2, 2014
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi there,
I hope you can help. am having some problems getting my head around Index and Match.
I have a requirement to pull data from a specific cell in a sheet based on two Criteria.
The Criteria are Week number, and Project number, and I want to return a specific weeks info.
in my spreadsheet I have the following:
Column A1:A20 lists the Project numbers. Cols B1 to M1 are the week numbers. Cells B2:M20 are the updates.
The master sheet works on a week number and project number basis - I want to say: If Project ="22" and Week Number="39", then display that cells info.
I hope this makes sense?
Thanks
Scott
I hope you can help. am having some problems getting my head around Index and Match.
I have a requirement to pull data from a specific cell in a sheet based on two Criteria.
The Criteria are Week number, and Project number, and I want to return a specific weeks info.
in my spreadsheet I have the following:
Column A1:A20 lists the Project numbers. Cols B1 to M1 are the week numbers. Cells B2:M20 are the updates.
The master sheet works on a week number and project number basis - I want to say: If Project ="22" and Week Number="39", then display that cells info.
I hope this makes sense?
Thanks
Scott