How to get data without using VBA

[thisisrahul]

hi,
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

 

[thisisrahul]

got the solution after trying for around 1 hr.

 

[raj2206]

Hi, Could you post the formula.

Thanks,Raj