Chris,

I would insert a new column (A) in the worksheet (Sheet 1) with the ID no
and enter a concatenate formula =C1&" "&D1&" "&E1 in this column which will
yield for eg

Smith Chris 22260

Where 22260 is the date no for 10 Dec 1960

And then in the worksheet (Sheet 2) where you require the ID no enter the
following Vlookup formula in cell A1 and copy down as far as necessary.

=Vlookup(=B1&" "&C1&" "&D1,Sheet2!A1:B1000,2,false)

This will do away with using If statements but it does require all names to
be spelt correctly on both sheets and no input errors with the birth dates.

Hope this helps.
Ian Grega

"Chris" wrote:

I have a list which contains a full list of names and corresponding ID numbers:

A1: ID#
B1: SURNAME
C1: FIRST_NAME
D1: DOB

I have another worksheet where I have a subset of the names and need to
populate the ID# if the SURNAME, FIRST_NAME and DOB match.

A1: currently blank but need to populate ID#
B1: SURNAME
C1: FIRST_NAME
D1: DOB

Can anyone help?

Thanks

Chris