L
Legacy 462336
Guest
I have a file with two tabs. Tab one has data - Week, Rating, Score information that I manually enter in each week highlighted in yellow. Tab two has data - Week, Dept, Total Hr, Total Output, OPLH information that I use to get my OPLH grand total that I enter into the rating column in tab one. Example: Tab two Cell D46 is what I manually enter into Tab one Cell C3 and so on for each week.
Basically, I'm looking for a formula or method to take the second tab Cell D46 information each time the pivot table is generated for the week and be placed in the appropriate Rating column based in tab one. Something like In tab one Cell C3 I would have a formula =Vlookup(B3, "Select the range from tab 2" A1:J46, then I'm lost because I have not instructed excel that once it finds the correct date 10/5/2020 in this case, then select the data in cell D46. The same goes for using the offset formula and......so on. Any help is appreciated. Once the formula is generated I will copy it down column C on tab one and the appropriate rating will appear.
Basically, I'm looking for a formula or method to take the second tab Cell D46 information each time the pivot table is generated for the week and be placed in the appropriate Rating column based in tab one. Something like In tab one Cell C3 I would have a formula =Vlookup(B3, "Select the range from tab 2" A1:J46, then I'm lost because I have not instructed excel that once it finds the correct date 10/5/2020 in this case, then select the data in cell D46. The same goes for using the offset formula and......so on. Any help is appreciated. Once the formula is generated I will copy it down column C on tab one and the appropriate rating will appear.