Get data against drop down using Index Match Formula Please help

[JawaharPrem]

Hi,

Descriptions Of Items and following coloums data to updated againts vendor name provide in drop down box i tried "index & match" formula but the same not working. can you help on same.

=IFERROR(INDEX($B$4:$H$4,AGGREGATE(15,6,(ROW($B$4:$H$4)-ROW(I4)+1)/($B$4:$H$4=$L$2),ROWS($1:1)),MATCH($L$2,B4:H4,0)),"")

Thanks
Jawahar Prem

 

[JawaharPrem]

Sorry forget to upload file

 

[PCosta87]

Hi,

Perhaps something like this (see attached)

 

[bosco_yip]

1] M2, copy across and down :

=IFERROR(INDEX($B$4:$H$89,AGGREGATE(15,6,(ROW($B$4:$B$89)-ROW($B$4)+1)/($I$4:$I$89=$L$2),ROWS(M$2:M2)),MATCH(M$1,$B$2:$H$2,0)),"")

2] see attached

Regards
Bosco

 

[JawaharPrem]

Hi,

i found my mistake i will correct.

Thanks a lot for Pcosta & Bosco.

Regards
Jawhar Prem