Hi,

I have two lists. One is a comprehensive list and the other is a simple
list. I am trying to import data from the simple list into the comprehensive
list.

Comprehensive List

A B C
D
1 First Name Second Name Address Code
2 John Doe 123 blah blah
3 Peter Smith 456 blah blah
etc

Now in this list the cells under the code column are all blank but all
others have values

Simple List

A B C
1 First Name Surname Code
2 Ben Dover 1234
3 Amanda Huginkiss 5678
etc etc

I need to look up the first name and the surname in the simple list and
return the code value into the comprehensive list.

Vlookup will lookup one cell reference.

Thoughts??