Bobsie0202
New Member
- Joined
- Dec 2, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
- MacOS
HI,
I'm looking for a formula, I have a workbook and at current =PROPER(INDEX('V25 TRACKER'!H:H,MATCH(C15,'Cargo'!E:E,0))) use this formula so extract the info from a different tab. But I need to add another criteria
If column E on workbook 1 matches Column C on workbook 2 & If Column K on workbook 1 matches Cell B10 on workbook 2 then extract the data from column H and pull it through to workbook 2
I hope that makes sense. Basically if two names on diff workbooks match, if tow dates match to a specific cell. then extract the info
I'm looking for a formula, I have a workbook and at current =PROPER(INDEX('V25 TRACKER'!H:H,MATCH(C15,'Cargo'!E:E,0))) use this formula so extract the info from a different tab. But I need to add another criteria
If column E on workbook 1 matches Column C on workbook 2 & If Column K on workbook 1 matches Cell B10 on workbook 2 then extract the data from column H and pull it through to workbook 2
I hope that makes sense. Basically if two names on diff workbooks match, if tow dates match to a specific cell. then extract the info