11 August 2010
i have two worksheets ws1 is prepared based on pivot table of ws2, now in ws1 i want to get the description of items from ws2 relevant for two VAT rate so that in ws1 the description relevant for vat rate 4% will be appeared in the 4% column of ws1 and description of 12.5% will be appear in 12.5% rate. Applying simple Vlookup i am getting wrong result.