Vllookup pull data row and column filter

[gokulu]

Hi,

kindly help me out to get the data extract from source

Data source is :

Date	name	open	close	low
01-Jul	a	12	51	89
01-Jul	b	13	535	846
01-Jul	c	846	351	784
02-Jul	a	456	56	-344
02-Jul	b	89	31	-27
02-Jul	c	311	84	-143
03-Jul	a	468	48	-372
03-Jul	b	318	78	-162
03-Jul	c	846	888	930

<colgroup><col width="61" span="5" style="width:46pt"> </colgroup><tbody>
</tbody>

Preferred out put:

name	D
	open	close	low
01-Jul
02-Jul
03-Jul

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

After typing the name rest data to be pull from source data

 

[wideboydixon]

Book1
	A	B	C	D	E	F	G	H	I	J
1	Date	Name	Open	Close	Low		Name:	b
2	01-Jul	a	12	51	89			Open	Close	Low
3	01-Jul	b	13	535	846		01-Jul	13	535	846
4	01-Jul	c	846	351	784		02-Jul	89	31	-27
5	02-Jul	a	456	56	-344		03-Jul	318	78	-162
6	02-Jul	b	89	31	-27
7	02-Jul	c	311	84	-143
8	03-Jul	a	468	48	-372
9	03-Jul	b	318	78	-162
10	03-Jul	c	846	888	930
Sheet1

Cell Formulas
Range	Formula
H3	{=VLOOKUP($G3&$H$1,CHOOSE({1,2},$A$2:$A$10&$B$2:$B$10,C$2:C$10),2,0)}
I3	{=VLOOKUP($G3&$H$1,CHOOSE({1,2},$A$2:$A$10&$B$2:$B$10,D$2:D$10),2,0)}
J3	{=VLOOKUP($G3&$H$1,CHOOSE({1,2},$A$2:$A$10&$B$2:$B$10,E$2:E$10),2,0)}
Press CTRL+SHIFT+ENTER to enter array formulas.

WBD

 

[Special-K99]

Its not clear from your output what you want it to look like.
What's "D" in your output for a start?
Where is name in realtion to the rest of the table? is it a column of names you want or a report-like output?

Do the same as you've done on your original table (put boxes round the output) so we know what format you want it to be