srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,860
- Office Version
- 365
- Platform
- Windows
I have company names in column A, invoice numbers in column B and months In row 6, I want to copy the cell from an old sheet in a workbook to a new similar sheet in a different workbook. I want the Formula to match the Company names that are repeated a few times and match invoice Number that is unique and read the month in the column heading and bring the corresponding value.
I used basic Index and match function, that works but has its limitations, I want the formula if I change the month heading so it should fetch the value from that month in the cell.
The formula I am using is,
=INDEX('[NonOp Checklist 09 2018 New.xlsx]SOHAIL'!$T$6:$T$79,MATCH(C56,'[NonOp Checklist 09 2018 New.xlsx]SOHAIL'!C$6:C$79,0))
Regards,
I used basic Index and match function, that works but has its limitations, I want the formula if I change the month heading so it should fetch the value from that month in the cell.
The formula I am using is,
=INDEX('[NonOp Checklist 09 2018 New.xlsx]SOHAIL'!$T$6:$T$79,MATCH(C56,'[NonOp Checklist 09 2018 New.xlsx]SOHAIL'!C$6:C$79,0))
Regards,
