Hi,
I have a worksheet. There are two sheets inside it. one is portfolio and second is summery. in database sheet I have list of clients. In a summery sheet I want appear portfolio sheet data in a summery sheet format.
what i am looking for??
1. in a summery sheet I will select only client name (cell marked in wooden color). Once I select client name according to that all fields marked in yellow will fetch data from portfolio sheet. I tried to do it with vlookup formula and got success to fetch address, bank details cell data. But when I come to downside where there are multiple data rows in portfolio sheet, there only first line is showing an if i copy/paste the same formula to next line than same data is coming.
please help.
Sample worksheet is attached.
Bookmarks