Sarath Karanam
New Member
- Joined
- Mar 14, 2013
- Messages
- 41
Hi,
I'm trying this scenario without any luck so far.
I have a set of values in "Sheet1" which I have to vlookup from 2 other sheets using a macro.
Sheet1:
<tbody>
</tbody>
Sheet2:
<tbody>
</tbody>
Sheet3:
<tbody>
</tbody>
Here, I need to check if any Book from "Sheet1" is matching with Books of "Sheet2" and "Sheet3".
And, if it matches, I need both the results in the following way.
In "Sheet1" beside "Book 1" I need a drop down with both "Week 1" and "Week 3".
When I select "Week 1" from the drop down, I should get "AB" in the "Name" column.
When I select "Week 3" from the drop down, I should get "GH" in the "Name" column.
For "Book 4" in "Sheet1" it should just say "Week 4" and "GH" in the consecutive columns as those are the only values matching.
I'm not sure if this is possible. Can someone please help me.
Regards,
Sarath Karanam
I'm trying this scenario without any luck so far.
I have a set of values in "Sheet1" which I have to vlookup from 2 other sheets using a macro.
Sheet1:
Book Title | Week Number | Name | |
Book 1 | |||
Book 4 |
<tbody>
</tbody>
Sheet2:
Book Title | Week Number | Name | |
Book 1 | Week 1 | AB | |
Book 2 | Week 2 | CD | |
Book 3 | Week 3 | EF | |
Book 4 | Week 4 | GH |
<tbody>
</tbody>
Sheet3:
Book Title | Week Number | Name | |
Book 1 | Week 3 | GH | |
Book 3 | Week 1 | CD |
<tbody>
</tbody>
Here, I need to check if any Book from "Sheet1" is matching with Books of "Sheet2" and "Sheet3".
And, if it matches, I need both the results in the following way.
In "Sheet1" beside "Book 1" I need a drop down with both "Week 1" and "Week 3".
When I select "Week 1" from the drop down, I should get "AB" in the "Name" column.
When I select "Week 3" from the drop down, I should get "GH" in the "Name" column.
For "Book 4" in "Sheet1" it should just say "Week 4" and "GH" in the consecutive columns as those are the only values matching.
I'm not sure if this is possible. Can someone please help me.
Regards,
Sarath Karanam