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
Bookmarks