SOLVED

How to use an if and statement

Brass Contributor

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:

LocationGroupJanuary 1January 2January 3
Aaa   
Abb   
Bcc   

 

Tab 2:

LocationGroupJanuary 1January 2January3
Aaa054
Abb002
Bcc10020

 

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.

best response confirmed by nattiej101 (Brass Contributor)
Solution

@nattiej101 HSTACK() should work for you.

=HSTACK(JAN:FEB!C2:I14)

Harun24HR_0-1671001807055.png

 

 

1 best response

Accepted Solutions
best response confirmed by nattiej101 (Brass Contributor)
Solution

@nattiej101 HSTACK() should work for you.

=HSTACK(JAN:FEB!C2:I14)

Harun24HR_0-1671001807055.png

 

 

View solution in original post