PDA

View Full Version : Lookup value in column and get result from relevent page



vradhak7
08-02-2016, 10:07 PM
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
08-03-2016, 08:59 AM
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
08-04-2016, 10:48 AM
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?