Lookup value in column and get result from relevent page

Hello VBA Experts,
I have attached the file for reference.
The VBA tool has to lookup the value in column B and C in worksheet "Dashboard" from worksheet "Group1" and "Group2" depending on the values in column B and C.

There are some constraint which goes into finding the value:
We need values of first "Tuesday" only to be displayed in the worksheet "dashboard".
For values in column F of worksheet "Dashboard" the tool has to lookup value "100%" under column D( worksheet "Group1" and "Group2") corresponding to the value in column B and C of worksheet "Dashboard".
For values in column G of worksheet "Dashboard" the tool has to lookup value "Cat volume" under column D( worksheet "Group1" and "Group2") corresponding to the value in column B and C of worksheet "Dashboard".
For values in column I of worksheet "Dashboard" the tool has to lookup value "Variable volume" under column D( worksheet "Group1" and "Group2") corresponding to the value in column B and C of worksheet "Dashboard".
For values in column F of worksheet "Dashboard" the tool has to lookup value "Pub volume" under column D( worksheet "Group1" and "Group2") corresponding to the value in column B and C of worksheet "Dashboard".

Automating this process would be greatly appreciated!
Regards
vradhak7

Other forum posted:

http://www.vbaexpress.com/foru…-page&p=347185#post347185

Re: Lookup value in column and get result from relevent page

StephenR- Yes, the expected answer in the first row should be 50/345/568/46 .

Re: Lookup value in column and get result from relevent page

@stephenR..Did you mean I need to reciprocate the answer in the other link ? Thanks!