Forum Discussion
Solved
How to use an if and statement
I am trying to link a bunch of tabs together in excel - but I'm not sure the best formula to reuse over and over to get the input.
Here is an example of what I'm working with:
Tab 1:
| Location | Group | January 1 | January 2 | January 3 |
| A | aa | |||
| A | bb | |||
| B | cc |
Tab 2:
| Location | Group | January 1 | January 2 | January3 |
| A | aa | 0 | 5 | 4 |
| A | bb | 0 | 0 | 2 |
| B | cc | 10 | 0 | 20 |
I have a tab (like tab 2) for each month. So I have 13 tabs in total that I am working with.
I would like to combine all of this information onto one tab (tab1). How would I create a formula to connect these together?
This is what I created at first, but it won't drag and paste. Thanks in advance.
=IF(AND('tab1'!C2='tab2'!E$3,'tab1'!$C4='tab2'!B3),'tab2'!E4,'tab2'!E4)
3 Replies
- Combine then what? Your question is incomplete. Attach a sample file and show your desired output. TOCOL(), VSTACK() may help.
Harun24HR Attached is a test dataset/example of what I'm looking for.
There is a tab of all the data that needs to be linked to the other month tabs. Hope this makes more sense. The first tab is all of the information from the other tabs.
