Hi

I have a list that will have a reference number in column A from 1 to 2000
with additional information in column b and c.

so will be like

A B C D
1 yes 23 (blank)


I will be pasting a list under this list with the same setup excet in column
d it will have another reference point such as 10.

A B C D
1 yes 23 10

The list will be contain most of the top list and i would like to top list
to check the list underneath matching the reference number and to return what
is in column D on the new list to match what is in column D on the new list
there will be a few that don't match and could be highlighted False so i can
deal with them.

Any ideas would be great as i know there is a lookup function but not sure
what is best to do.( and easiest).

Many thanks for looking