Base on Dropdown list cell, vlookup into another sheet

[kevin1979]

hello everyone,

i tried to search through the forum but i couldn't find a correct solution to my problem.

So hope that you guys could help me on this. =)

1. under sheet A, i have dropdown list from Jan to Dec and there are multiple cells
2. So if i select "Jan" in sheet A, the multiple cells will vlook the data into sheet B for "Jan" data.
3. If i select "Mar" in sheet A, the cells will change all data to "Mar" data based on sheet B.
2. Sheet B will be my master data file

Thank you =)

[Special-K]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[kevin1979]

hello Special -K,
please refer to the attached

[Bo_Ry]

Please try at
E4
=INDEX('Master data'!$E$4:$Q$27,MATCH($B4,'Master data'!$A$4:$A$27,)+IFERROR(MATCH(E$3,'Master data'!$D$4:$D$7,),4)-1,MATCH($E$1,'Master data'!$E$2:$E$3,))

F4:G4
=INDEX('Master data'!$E$4:$Q$27,MATCH($B4,'Master data'!$A$4:$A$27,)+IFERROR(MATCH(F$3,'Master data'!$D$4:$D$7,),4)-1,MATCH($E$1,'Master data'!$E$2:$E$3,))

copy E4:G5 to E6 and E8