Vlook ups help please

Attached is the sheet.

Col A is names, B is Date started and C the FTE.

I would like to be able to select a date from a list (I can do that bit) and the calulation show me the FTE on that date.

Can someone please help me?

Thanks in advance.

J

VLOOKUP will get the first

=VLOOKUP(E4,B:C,2,FALSE)

but there are many for each date.

I have modified your sheet using the Vlookup but as you have duplicate dates it will only find the first entry.

I think my explaination is not as clear as I wanted it to be so iam sorry if i have wasted peoples time.

I want to be able to pick any date and it give me the FTE

example

if I pick 01/01/2012 I want it to show me every FTE number Prior to this date.

Tom 1977 yours seems to be what iam looking for can you add the above in?

Again sorry I wasnt clearer.

How about just using conditional formating to hide what you do not want to see ? ( see sheet )

BarryTSL, that would work but I need a running total for the FTE at each date.

Tom perfect thank you