Excel Vlookup and multiple search results

[rupeshp]

Require your great support to resolve my issue for multi vlookup in excel sheet:

I Want to search value from excel sheet1 B coloum (Account No) data range with sheet2. As per lookup value every match data and there corresponding value shall copy in sheet1 C column, D column

Find the attached sheet for the same.

[avichandana]

Require your great support to resolve my issue for multi vlookup in excel sheet:

I Want to search value from excel sheet1 B coloum (Account No) data range with sheet2. As per lookup value every match data and there corresponding value shall copy in sheet1 C column, D column

Find the attached sheet for the same.

Done.

Note : if you change anything in formula press Ctrl+Shift+Enter to take effect.