Need help please TABLE

[Santosh080]

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]

[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]

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

 

[Santosh080]

My Question is :


Sheet 1:

Sheet 2

 

[MARZIOTULLIO]

[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​

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

3​

[/TD]
[TD]

4124​

[/TD]
[TD]

9999​

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

4​

[/TD]
[TD]

4124​

[/TD]
[TD]

2222​

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

5​

[/TD]
[TD]

4124​

[/TD]
[TD]

1111​

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

6​

[/TD]
[TD]

4124​

[/TD]
[TD]

3333​

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

7​

[/TD]
[TD]

4125​

[/TD]
[TD]

5555​

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

8​

[/TD]
[TD]

4125​

[/TD]
[TD]

7777​

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

9​

[/TD]
[TD]

4125​

[/TD]
[TD]

4444​

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

10​

[/TD]
[TD]

4125​

[/TD]
[TD]

6666​

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

11​

[/TD]
[TD]

4125​

[/TD]
[TD]

5555​

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

 

[Santosh080]

thanks very very very much.
Now it working

 

[MARZIOTULLIO]

you are welcome