Need help please TABLE

[Santosh080]

HELLO FRIENDS NEED SOME HELP

Sheet 2 data LIKE THIS

A	111	qwe
A	222	aas
A	333	saa
B	77	ZSA
B	78	SDSA
B	998	ASA

<tbody>
</tbody>

A

<tbody>
</tbody>

I WANT DATA IN SHEET 1

111	QWE
222	AAS
333	SAA

<tbody>
</tbody>

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]

	A​	B​	C​
1​	111​	qwe	sheet1
2​	222​	aas
3​	333​	saa

<tbody>
</tbody>

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
​

	A​	B​	C​
2​	A	111​	qwe
3​	A	222​	aas
4​	A	333​	saa
5​	B	77​	ZSA
6​	B	78​	SDSA
7​	B	998​	ASA

<tbody>
</tbody>

 

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

<tbody>
</tbody>

	A​	B​	C​	D​	E​	F​
1​	sheet1				no	4124​
2​	rank
3​	8888​
4​	9999​
5​	2222​
6​	1111​
7​	3333​

<tbody>
</tbody>

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}

	A​	B​	C​
1​	no	rank	sheet2
2​	4124​	8888​
3​	4124​	9999​
4​	4124​	2222​
5​	4124​	1111​
6​	4124​	3333​
7​	4125​	5555​
8​	4125​	7777​
9​	4125​	4444​
10​	4125​	6666​
11​	4125​	5555​

<tbody>
</tbody>

 

[Santosh080]

thanks very very very much.
Now it working

 

[MARZIOTULLIO]

you are welcome