IF & VLOOKUP
 

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!

IF & VLOOKUP
 

You need to have the formula in worksheet B to "pull" data from
worksheet A, and you also want to match on both the date AND the
account number. In worksheet A, insert a new column C and in C2 enter
this formula:

=A2&B2

This joins the two columns together to form a unique key. Copy this
formula down column C for as many data items as you have (assume this
is 500).

Then in column C of worksheet B enter this formula in C2:

=VLOOKUP(A2&B2,'worksheet A'!C$2:D$500,2,0)

and copy this formula down column C for as many items as you have in
columns A and B.

Hope this helps.

Pete

Dr Phibes wrote:
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!