formula for combining

Yossi

New Member
thanks for taking your time and trying to help out

i would like book1 to be the results from book2 plus book3 in a formula

 book1 b c d e f g l t

<tbody>
</tbody>

 book2 book3 b b c c g d l e t f

<tbody>
</tbody>

BenMiller

Board RegularThe ONLY cool kid on the block
With book 2 and book 3 in columns A and B (let's say from A1:B8), put this array formula in C2 (you must leave C1 blank above it) and confirm it with CTRL+SHIFT+ENTER:

=IF(ISNA(INDEX(\$A\$1:\$A\$8,MATCH(0,COUNTIF(C\$1:C1,\$A\$1:\$A\$8),0))),INDEX(\$B\$1:\$B\$8, MATCH(0,COUNTIF(C\$1:C1,\$B\$1:\$B\$8),0)),INDEX(\$A\$1:\$A\$8, MATCH(0,COUNTIF(C\$1:C1, \$A\$1:\$A\$8),0)))

T. Valko

Well-known Member
thanks for taking your time and trying to help out

i would like book1 to be the results from book2 plus book3 in a formula

 book1 b c d e f g l t

<TBODY>
</TBODY>

 book2 book3 b b c c g d l e t f

<TBODY>
</TBODY>

What version of Excel are you using?

Yossi

New Member
i tried this
why doesn't it work?
=IF(ISNA(INDEX(last_week_pivot_inven!\$A\$5:\$A\$99999,MATCH(0,COUNTIF('sub_total'!A\$2:A2,last_week_pivot_inven!\$A\$5:\$A\$99999),0))),INDEX(current_week_pivot_inven!\$A\$5:\$A\$99999, MATCH(0,COUNTIF('sub_total'!A\$2:A2,current_week_pivot_inven!\$A\$5:\$A\$99999),0)),INDEX(last_week_pivot_inven!\$A\$5:\$A\$99999,MATCH(0,COUNTIF('sub_total'!A\$2:A2,last_week_pivot_inven!\$A\$5:\$A\$99999),0)))

Excel 2010

1,082,017
Messages
5,362,695
Members
400,686
Latest member
Aakash

This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...