Hi,

I am a total beginner in Excel, VLOOKUPS etc.

I want to do the following but I am not too sure of the syntax. Help would
be greatly appreciated.

I have 2 workbooks.

In workbook A I have a date, an account number and some information

in workbook B I have a date, an account number and the need to take
information from workbook A and insert it into workbook B

I have also got the following but it's not working..This is in Workbook A

=IF((C8<'WORKBOOK B'!A2),VLOOKUP(D8,'WORKBOOK B'!$A:$D,2,FALSE))

Basically, I need the dates to match in order to look up the account number
with the V lookup and give me the data next to the account number.

Where am I going wrong?

Many thanks!