Vlookup Array formula should return multiple values

[Ateeb Ali]

Dear Sir,
File enclosed.

Sheet4: when out rfq number in cell A2
it should return multiple values in each column from "data" sheet

 

[rahulshewale1]

Dear ateeb,


PFA solution attached


see if it is ok?


Regard
Rahul shewale

 

[Khalid NGO]

Hi,

Or this with just enter:

=IFERROR(INDEX(Data!$B$2:$H$2644,AGGREGATE(15,6,1/((Data!$A$2:$A$2644=$A$2)/(ROW(Data!$A$2:$A$2644)-1)),COUNTIF($A$2:$A2,$A2)),COLUMN(A1)),"")

Regards,

 

[Peter Bartholomew]

Much the same formula - different construction.
This will be so much simpler once dynamic arrays come to town!

 

[Ateeb Ali]

Thanks ninjas, these both works