Hi,

I am having a problem setting up a formula that uses data from one
spreadsheet and returns a value in another.

Here are my spreadsheets:

Spreadsheet 1:
Col. A Col. B Col. C
1 Surname Firstname Classification
2 Bloggs Joe Management
3 Jones Fred Engineer
and so on

Spreadsheet 2:
Col. B Col. C Col. I
1 Surname Firstname Classification
2 Bloggs Joe
3 Jones Fred

In I2 (spreadsheet 2) I have the formula:
=vlookup(B1,'Spreadsheet2'!$A$2:$B$200,3) to get Management

This formula works fine when there is only one person with each surname.
When there are two people with the same surname, i.e. Joe Bloggs and John
Bloggs I don't get the correct result.

Can anyone help me?

Thanks

James

--
J