How to get data from specific cell and to find a value in a table & pull a whole table in other sheet.

[Farooqui Noor]

I am here showing a sample data of family tree in sheet No. 1. However the data is huge and 3 to 4 hundred tables of names (Tables are making by using Ctrl + T) are present in many sheets including sheet No.1.
1) In sheet No. 1 there is a sample data is available. in sample data there are many tables containing names associated with there number.
2) I want to obtained a result as shown in sheet No. 2. If we entered any value in cell F3, formula should search F3 value in sheet No.1 and display the associated name in sheet 2 in I3 cell.
3) I will provide all reference data for the formula as per sheet No. 3. (In sheet No. 2 (F3 cell) If I will put any number than the result should comes in the form of tables as shown in sheet No.2 by using formula. Is it possible.

conclusion: I want the result as shown in sheet No.2 1) when i will type any number in F3 cell the result should be as per i3 2) and i want three whole tables data as per shown in sheet2 which is depend upon F3 value.

Shijra sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1
2
3				expire	w	No.	Table No. 25	M	Birth						expire	w	No.	Table No. 25	M	Birth
4						1235M	niyazuddin										3248M	peerzade zafaruddin
5						6478F	sharif bi										3641F	tabassum begam
6
7				expire	w	No.	Table No. 25	M	Birth						expire	w	No.	Table No. 25	M	Birth
8						245M	waziruddin										1587M	peerzade qutbuddin
9						246M	shakiluddin										3641M	peerzade islahuddin
10						487F	salam bi
11						568M	alimuddin								expire	w	No.	Table No. 25	M	Birth
12																	6478M	peerzade rahimuddin
13				expire	w	No.	Table No. 25	M	Birth								3548F	maryam bi
14						695M	muhammad uddin										1876F	shahadat bi
15						1245M	salahuddin										6472F	ibadat bi
16						148F	muzaffar ali
17						255F	rihana begam								expire	w	No.	Table No. 25	M	Birth
18						1478F	hajera begam										6412M	raeesuddin
19						4578F	qubra bi										5739M	jamiluddin
20																	5179M	sharifuddin
21				expire	w	No.	Table No. 25	M	Birth								3498M	fakhruddin
22						325F	sultana bi										6172F	firoz bi
23						1459M	azimuddin
24						2145M	ejazuddin
25						6589M	fasihuddin
26						1479M	kalimuddin
27
Sheet1

Shijra sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1		when I will put any number in cell F3 following result should be displayed in i3, F8 (Table No. 25511), O8 (Table No. 2510) and F14 (Table No. 25) . Is it possible											Result
2
3						6478M			peerzade rahimuddin		My Name
4
5				My Number ( It is not necessary that this number is present in sheet 1, it may be available in sheet 4 or sheet 5 etc.)
6
7									My Father & paternal uncles and aunts									My Mother & maternal uncles and aunts
8						expire	w	No.	Table No. 25	M	Birth				expire	w	No.	Table No. 25	M	Birth
9	My paternal Uncle							1587M	peerzade qutbuddin								3248M	peerzade zafaruddin					My maternal uncle
10	My Father							3641M	peerzade islahuddin								3641F	tabassum begam					My Mother
11
12
13									My wife and her brothers and sisters
14						expire	w	No.	Table No. 25	M	Birth
15	My wife's brother							1235M	niyazuddin
16	My wife							6478F	sharif bi
17
Sheet2

Shijra sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1						For reference
2
3			sheet No.	My wife Table No.		sheet No.	My Mother's Table No.		sheet No.	My Father's Table No.		sheet No.	My Table No.	My Number
4			1	25		1	2510		1	25511		1	25612	6478M
5
6
7
Sheet3

 

[Fluff]

Duplicate to: How to apply Formula in Family Tree

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.