Need help please TABLE

Santosh080 · Jul 29, 2017

HELLO FRIENDS NEED SOME HELP

Sheet 2 data LIKE THIS
[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]111[/TD]
[TD]qwe[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]222[/TD]
[TD]aas[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]333[/TD]
[TD]saa[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]77[/TD]
[TD]ZSA[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]78[/TD]
[TD]SDSA[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]998[/TD]
[TD]ASA[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[/TR]
</tbody>[/TABLE]

I WANT DATA IN SHEET 1

[TABLE="width: 500"]
<tbody>[TR]
[TD]111[/TD]
[TD]QWE[/TD]
[/TR]
[TR]
[TD]222[/TD]
[TD]AAS[/TD]
[/TR]
[TR]
[TD]333[/TD]
[TD]SAA[/TD]
[/TR]
</tbody>[/TABLE]

I WANT USE VLOOKUP LIKE FUNCTION SO THAT I CAN SEARCH/PUT FOR "A" OR "B" IN A CELL AND IT RETURN THE COLUMN WISE DATA FROM SHEET 2 AS IN EXAMPLE SHEET 1 (PLEASE NO VBA CODE METHOD, I HAVE NO IDEA ABOUT VBA)

CAN IT POSSIBLE?

PLEAE HELP

MARZIOTULLIO · Jul 29, 2017

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A

[/TD]
[TD]

B

[/TD]
[TD]

C

[/TD]
[/TR]
[TR]
[TD]

1

[/TD]
[TD]

111

[/TD]
[TD]qwe[/TD]
[TD]sheet1[/TD]
[/TR]
[TR]
[TD]

2

[/TD]
[TD]

222

[/TD]
[TD]aas[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3

[/TD]
[TD]

333

[/TD]
[TD]saa[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

a1=IFERROR(INDEX(Sheet2!$B$2:$B$7,SMALL(IF(Sheet2!$A$2:$A$7=Sheet2!$A$2,ROW(Sheet2!$B$2:$B$7)-ROW(Sheet2!$B$2)+1),ROWS(Sheet2!$B$2:Sheet2!B2))),"") control+shift+enter copy down

b1=IFERROR(VLOOKUP(Sheet1!A1,Sheet2!$B$2:$C$7,2,0),"") copy down

SHEET2
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A

[/TD]
[TD]

B

[/TD]
[TD]

C

[/TD]
[/TR]
[TR]
[TD]

2

[/TD]
[TD]A[/TD]
[TD]

111

[/TD]
[TD]qwe[/TD]
[/TR]
[TR]
[TD]

3

[/TD]
[TD]A[/TD]
[TD]

222

[/TD]
[TD]aas[/TD]
[/TR]
[TR]
[TD]

4

[/TD]
[TD]A[/TD]
[TD]

333

[/TD]
[TD]saa[/TD]
[/TR]
[TR]
[TD]

5

[/TD]
[TD]B[/TD]
[TD]

77

[/TD]
[TD]ZSA[/TD]
[/TR]
[TR]
[TD]

6

[/TD]
[TD]B[/TD]
[TD]

78

[/TD]
[TD]SDSA[/TD]
[/TR]
[TR]
[TD]

7

[/TD]
[TD]B[/TD]
[TD]

998

[/TD]
[TD]ASA[/TD]
[/TR]
</tbody>[/TABLE]

Santosh080 · Jul 29, 2017

thanks very much

i try it but i can not get result. I may be doing something wrong.

Santosh080 · Jul 29, 2017

My Question is :

Sheet 1:

Sheet 2

MARZIOTULLIO · Jul 30, 2017

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A

[/TD]
[TD]

B

[/TD]
[TD]

C

[/TD]
[TD]

D

[/TD]
[TD]

E

[/TD]
[TD]

F

[/TD]
[/TR]
[TR]
[TD]

1

[/TD]
[TD]sheet1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no[/TD]
[TD]

4124

[/TD]
[/TR]
[TR]
[TD]

2

[/TD]
[TD]rank[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3

[/TD]
[TD]

8888

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4

[/TD]
[TD]

9999

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5

[/TD]
[TD]

2222

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6

[/TD]
[TD]

1111

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7

[/TD]
[TD]

3333

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

a3=IFERROR(INDEX(Sheet2!$B$2:$B$11,SMALL(IF(Sheet2!$A$2:$A$11=Sheet1!$F$1,ROW(Sheet2!$B$2:$B$11)-ROW(Sheet2!$B$2)+1),ROWS(Sheet2!$B$2:Sheet2!B2))),"") control+shift+enter copy down

After you type in the formula, don't just press enter.
Instead, press CTRL + SHIFT + ENTER

If you've already entered the formula, then highlight the cell with the formula and press F2.
Then press CTRL + SHIFT + ENTER

When entered correctly, the formula will be enclosed in {brackets}

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A

[/TD]
[TD]

B

[/TD]
[TD]

C

[/TD]
[/TR]
[TR]
[TD]

1

[/TD]
[TD]no[/TD]
[TD]rank[/TD]
[TD]sheet2[/TD]
[/TR]
[TR]
[TD]

2

[/TD]
[TD]

4124

[/TD]
[TD]

8888