N
Neil
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
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