I have an excel file with some raw data in a sheet named "Raw", I need to build a table as shown in the sheet "Lookup". I have manually filled out cell b7 to b9 based on the table in the sheet called "list". Based on list, Val = dvd + ran which is =870+100 but I can't just put the sum of these numbers, 970, I need to put "=870+100".
From List,
que = nmf + tv1 =100+320
teq = UDF + vba + vhs =320+500+751
I thought that maybe I could use a pivot table shown in sheet "pivot" to help get the data organised and then look up the values but now I realise that the periods could go from 0, 1, 2, ... x and the cases can go from 1, 2, 3, 4, ... y. So my look up won't work.
I don't know how to reference the fields in the pivot sheet to go to the lookup sheet based on the formulas in the sheet "list".The raw data table could be very large so I thought the pivot table would be a good idea.
Is this the best way to do this or should I do something else? Any help would be appreciated.
Reply With Quote