Hi guys,

I am having an incredibly frustrating time attempting to understand the
above functions.

My Set up is as follows:

Sheet 1 (S1), - list of clients that acted between certain dates

Column A, Client Unique ID [text]
Column B, Date which client first acted.

Sheet 2 (S2) - list of clients signed up between certain dates
Column A, Clients sign up date
Column B, Clients Unique ID [text]
Column E, =COUNTIF(Sheet1!A:A,B2) ~ Number of Times client appears
on sheet 1


My Aim for S2 Column F.

IF, Column E in S2 0, to look up the corresponding first action date
for that client in S1.

Atm the formula I would of though to work correctly is:

=IF(E10,VLOOKUP(B1,Sheet2!A:B,2),"Not Acted")

However this brings the wrong date.

Please can anyone advise on this matter and let me know where i am
gonig wrong.

Many thanks.
Sp


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=572290