automatic Vlookup in 3 or more column

[jc83ph]

Hello!

Please I need your support to make the code or any idea on how to make one formula to display the details using the Vlookup in 3 or more columns.

Here is the sample.

Thank you in advance for your help.

Regards,

 

[arthurbr]

You probably can use the FILTER function, but your profile does not state your XL version, so...

 

[kevin9999]

2 options offered, the first if you have 365, the second if you don't...

Book1
	A	B	C	D
1	scanned	name	qty	price
2	123	banana	1	100
3
4	123	banana	1	100
5
Sheet2

Cell Formulas
Range	Formula
B2:D2	B2	=FILTER(Sheet1!B:D,Sheet1!A:A=A2,"")
B4:D4	B4	=VLOOKUP(A4,Sheet1!A:D,{2,3,4},FALSE)
Dynamic array formulas.

 

[jc83ph]

2 options offered, the first if you have 365, the second if you don't...

Book1
	A	B	C	D
1	scanned	name	qty	price
2	123	banana	1	100
3
4	123	banana	1	100
5
Sheet2

Cell Formulas
Range	Formula
B2:D2	B2	=FILTER(Sheet1!B:D,Sheet1!A:A=A2,"")
B4:D4	B4	=VLOOKUP(A4,Sheet1!A:D,{2,3,4},FALSE)
Dynamic array formulas.

thanks you so much fornl your help.

 

[kevin9999]

Happy to help & thanks for the feedback