Concatenate and Vlookup

Hi

I plan to use a category worksheet with Different Concatenate formulas to display products in different ways in a web store. I call up the Concatenate in the categories worksheet via a category number from the pricelist via Vlookup. This is okay.

One of the display formulas I have in the categories worksheet is

=CONCATENATE(p!D2,p!BM2,p!D2,p!BO2,p!D2,p!A2,p!D2,p!BS2,p!D2,p!B2,p!D2,p!BK2)
It shows "Eau De Toilette Spray by Carolina Herrera for Women"
Data taken from the pricelist.

The Above product is on Row 2.

I use the below in the pricelist to call the above Concatenate to give me the format I need for that item in the pricelist.
=(VLOOKUP(BQ2,'CATEGORY TABLE'!$A$1:$AH$4000,8,FALSE))
(bq2 is the lookup value as each Items belongs to a category)

How do I use the concatenate to display different products with the concatenate, Eg row's 3, 4, 5 are different items but it displays the same info as row 2 because I think it's taking the data already filled out in the formula that is on the category worksheet I use. Do I do a vlookup with the concatenate in the pricelist and don't use concatenate in the categories table like I have to then lookup the cell values. Or do I use the indirect function.

Any help would be muchly appreciated as my current spreadsheet is crashing my pc. Eg using nearly 3gb of ram due to 6 columns with about 3 dozen different variations of the above concatenate and many if formulas. On 10,000 rows.

Regards,
Aaron

Aaron

Can you put up a sample workbook that shows your structure and some data. Give an example of what you would like to return from that sample data.


rylo

Hi Rylo,

Thanks for getting back to Me.
I've uploaded a sample spreadsheet.

I have only put one category for the output as the file will be to large if I add
anymore than this.

If you look at the pricelist worksheet, you will see the correct data on Row 2.
Joop, next is Jazz on Row 3 but the data in the short name is the same as
row 2. The formula is okay, but the data is Row 2's.

I muchly appreciate your Help.

Regards,
Aaron

Thanks Nbvc.

Have upload as a Zip. Unfortunately it's in Excel 2000.

Regards,
Aaron