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

Use column E as a (temporary) helper column, and put this formula in
E1:

=A1&B1&C1

Copy this down your first list, and then continue copying it down your
second list. Then put this formula in D1:

=IF(ISNA(MATCH(E1,E$2010:E$5000,0)),FALSE,INDEX(D$ 2010:D
$5000,MATCH(E1,E$2010:E$5000,0)))

Copy this down your first list.

I have assumed your second list occupies rows 2010 to 5000 - adjust to
suit.

Once the formula is copied down column D, you can fix the values and
then delete column E.

Hope this helps.

Pete


On Mar 19, 4:33*pm, Neil wrote:
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