Using Vlookup for multiple conditions

**Jebrowsky** · 07-05-2013, 05:48 PM

Hi,

I've looked around on previous posts to fix my problem, but I have not had any luck getting this to work.

I am putting together a spreadsheet that shows all the different funds for different people. The spreadsheet shows the history of when the funds were added, and when they were deleted. I need a way to filter the data so that when I filter it just to show just the "added" funds, I will get only the funds that have not been deleted. Otherwise when I filter them to get just the "added" funds, I will get funds that show up as added, but really were deleted.

I've attached a mock spreadsheet as an example. I hope this explanation wasn't too confusing.
Thanks a lot in advance for any help.

(Oh also ignore column c (ticker) on the spreadsheet it is not important.)

Fund Spreadsheet example.xlsx

**FDibbins** · 07-05-2013, 05:50 PM

Hi and welcome to the forum

have you tried to filter on D - uncheck everyrthing but ADD?

**Jebrowsky** · 07-05-2013, 06:06 PM

Yes that is the problem. If I do that it will show only "add funds". But some of those "add funds" have been deleted. Not literally deleted off the spreadsheet, but re-entered in as deleted. The spreadsheet is a history so it shows past funds even if they are no longer in use, or "added".

So for example if I enter in fund Z, on 1/2/12, it is an "added" fund. If I delete the fund, it stays the same on the spreadsheet and we just add a new entry for fund Z with a new date, that says it has been deleted (del).

So when I sort them to only show the "add files" it shows old "add files" that have other entries saying they are deleted. What I'm trying to do is sort it so these old files do not show up.