Hi Forum ,

I have two worksheets . Worksheet ,NewList has two columns , FirstName
, LastName.
Worksheet ,MasterList has 3 columns, FirstName, LastName, Properties.
I want to add a third column ,Properties to worksheet ,NewList such
that it compares FirstName and LastName from MasterList and returns the
corresponding Properties value from MasterList.

The most important constraint here is that FirstName,LastName value
should be on the same row .
For e.g., FirstName(1),LastName(1) in NewList could be
FirstName(6),LastName(6) in MasterList and I need to return
Properties(6) from the MasterList into Properties(1) in NewList.
The values in brackets above refer to the row number.

Looks like this will involve , IF ,AND and MATCH functions together.

Hope this is not confusing .

I know this must have been asked and responded to by the experts
several times.

All the help will be very much appreciated.

Thanks,
Girish


--
Girish Punjabi
------------------------------------------------------------------------
Girish Punjabi's Profile: http://www.excelforum.com/member.php...o&userid=16048
View this thread: http://www.excelforum.com/showthread...hreadid=387693