SOLVED

How to use an if and statement

Occasional Contributor

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

Re: How to use an if and statement

Combine then what? Your question is incomplete. Attach a sample file and show your desired output. TOCOL(), VSTACK() may help.

Re: How to use an if and statement

@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 (Occasional Contributor)
Solution

Re: How to use an if and statement

@nattiej101 HSTACK() should work for you.

``=HSTACK(JAN:FEB!C2:I14)``