Is This Embedded in The COUNTIF() function???

D

dj_money

Hey, what's going on everyone. I just need some help here. In Excel,
I want to create a function that would link data from another Workbook
(Source). My _Source_Workbook__displays:

Column A1: Toy
Column A2: Toy
Column A3: Toy
Column B1: Aisle 4B
Column B2: Aisle 6C
Column B3: Aisle 6A

However, IN the _Destination_Workbook__I've done a COUNTIF() function
that Counts how many Aisle there was for this product TOY. I also
would like to display the AISLES within the same ROW too!!! Basically
I want it to display it like this:

Column A1: Toy
Column B1: 3
_<--_this_is_comes_from_the_countif_function_
Column C1: Aisle 4B
Column D1: Aisle 6C
Column E1: Aisle 6A

So, Exactly how can I accomplish this guys and ladies? Thanks, I
really need your help on this.
 
T

Toppers

Try in your Destination w/book:

=IF(COLUMN()-2<=$B1,INDIRECT("[MyBook1.xls]Sheet1!B"&(MATCH($A1,[MyBook1.xls]Sheet1!$A:$A,0)+COLUMN()-3)),"")

copy across to maximum expected columns for any product.

"Mybook1.xls" is the source w/book

This assumes all "toys" are in contiguous rows.
 
Top