MitchellDTExcel
New Member
- Joined
- Nov 12, 2020
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi, I have two tabs on my worksheet and I want to do the following:
SHEET1: Has a list of project numbers with their corresponding task numbers. Project numbers in the B column and task numbers in the C column.
SHEET2: Has a list of project numbers, their corresponding task numbers and task number values. Project numbers in the A column, task numbers in the B column and values in the E column.
I want excel to match the project number and task number in SHEET1, cell B6 and C6, to the same project number and task number in SHEET2, column A and column B and return the value in column E (on SHEET2).
SHEET1: Has a list of project numbers with their corresponding task numbers. Project numbers in the B column and task numbers in the C column.
SHEET2: Has a list of project numbers, their corresponding task numbers and task number values. Project numbers in the A column, task numbers in the B column and values in the E column.
I want excel to match the project number and task number in SHEET1, cell B6 and C6, to the same project number and task number in SHEET2, column A and column B and return the value in column E (on SHEET2).