AleemAM123
06-02-2014, 06:37 PM
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". :bug: 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.
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". :bug: 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.