Lookup value in column and get result from relevent page

[vradhak7]

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

[vradhak7]

For example. the expected answer in the first row should be 50/345/568/46 and the tool should autofill rest of the column.

[Leith Ross]

Hello vradhak7,

How will the macro determine which day to use?

Since Tuesday appears twice, how will the Tuesdays be distinguished from each other when entered?