Index Formula

[varmoh]

Hello,

I have been working on this excel for quiet sometime but not able to find a solution so please help!!!

There are three columns Product Number, Product Saleability and Template. The requestor needs to fill this form to make a request for multiple products. This template is then emailed to another department who will then use the appropriate template to create the products.

I am able to get different template details to populate for different location but not able to do it if the product is global, i.e, used in all the location.

The formula which I have used is =IF(ISERROR(INDEX($C$1:$D$9,SMALL(IF($C$1:$C$9=$B$20,ROW($C$1:$C$9)),ROW(1:9)),2)),"",INDEX($C$1:$D$9,SMALL(IF($C$1:$C$9=$B$20,ROW($C$1:$C$9)),ROW(1:9)),2))

Below is how I want my excel to look but at the moment, global shows only one line or one template

Product Number Product Saleability Location
123 Thailand Thailand template
456 Singapore Singapore Template
789 Hong Kong Hong Kong Template
102 Global Singapore Template
Hong Kong Template
Japan Template
Thailand template
123 Hong Kong Hong Kong Template
356 Japan Japan Template



Attachment 364247



I want the excel to show all the option for global and move to the next available line for the next entry.

Please help!!

[Tony Valko]

Can't see your pic.

Attach a SMALL sample file that shows us what result you expect.

A SMALL sample file will have about 20 rows worth of data. We don't need a file with 100's or 1000's of rows of data.

[varmoh]

Hi Tony,

I was not able to attach any document to thsi thread as it did not give me the attachment icon. I have posted a new thread under the Excel General forum, where it did let me attach my document.

Apologies for the inconvenience caused.

http://www.excelforum.com/excel-gene...x-formula.html