TkdKidSnake
Board Regular
- Joined
- Nov 27, 2012
- Messages
- 245
- Office Version
- 365
- Platform
- Windows
Hi all,
I am looking at potentially using the match function using two variables on one tab to two variables on a 2nd tab that will then report a value on the form a specific column in the 2nd tab to the 1st. I have tried to several variations but as of yet I am struggling to get anything that works hence now looking at the match function.
1st Tab: ECIL - Consolidated
Formula will be on tab "ECIL - Consolidated" looking at column A and Column D and then these need to match the following
2nd Tab: Schedule In Report
What is in column D on the 1st tab is in column E on this tab and what is in column D on the 1st tab is in column G of this tab.
Upon finding a match I would like it to report what is in column L
If anyone can help it would be greatly appreciated.
Thanks in advance
I am looking at potentially using the match function using two variables on one tab to two variables on a 2nd tab that will then report a value on the form a specific column in the 2nd tab to the 1st. I have tried to several variations but as of yet I am struggling to get anything that works hence now looking at the match function.
1st Tab: ECIL - Consolidated
Formula will be on tab "ECIL - Consolidated" looking at column A and Column D and then these need to match the following
2nd Tab: Schedule In Report
What is in column D on the 1st tab is in column E on this tab and what is in column D on the 1st tab is in column G of this tab.
Upon finding a match I would like it to report what is in column L
If anyone can help it would be greatly appreciated.
Thanks in advance