PDA

View Full Version : Excel Vlookup and multiple search results



rupeshp
12-31-2019, 03:02 AM
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
01-21-2020, 02:14 AM
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.