thisisrahul
Active Member
- Joined
- Sep 2, 2008
- Messages
- 285
hi,
i've data as mentioned below:-
<tbody>
</tbody>
In input table i've daywise price of scrips in different columns. In the output table i want to get price as per the respective dates & scrip.
i was trying to vlookup but got stuck in defining dynamic range.
Is there a way that i can get this output without using VBA.
___________
Rahul
i've data as mentioned below:-
Input | ||||||||
Reliance | Price | DLF | Price | COAL | Price | |||
15-Del-2013 | 1000 | 20-Dec-2013 | 800 | 12-Nov-2013 | 300 | |||
16-Del-2013 | 2000 | 22-Nov-2013 | 850 | 5-Oct-2013 | 310 | |||
Output | ||||||||
15-Del-2013 | 16-Dec-2013 | 20-Dec-2013 | 12-Nov-2013 | 5-Oct-2013 | 22-Nov-2013 | |||
Reliance | 1000 | 2000 | ||||||
DLF | 800 | 850 | ||||||
COAL | 300 | 310 | ||||||
<tbody>
</tbody>
In input table i've daywise price of scrips in different columns. In the output table i want to get price as per the respective dates & scrip.
i was trying to vlookup but got stuck in defining dynamic range.
Is there a way that i can get this output without using VBA.
___________
Rahul