Help - Simple Formula !

[Girish Punjabi]

Hi Forum ,

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

The most important constraint here is that FirstName,LastName valu
should be on the same row .
For e.g., FirstName(1),LastName(1) in NewList could b
FirstName(6),LastName(6) in MasterList and I need to retur
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 expert
several times.

All the help will be very much appreciated.

Thanks,
Giris

 

[duane]

i assumed your master list is in columns a-c. if you can put in
column d where d2 = a2&b2 and copied down. then

=OFFSET(Sheet1!C1,MATCH(A2&B2,Sheet1!D24,0),0)

where my sheet1 is your master list sheet

and my a2 and b2 are the names on newlist

note i only did this for 3 rows (2:

 

[Earl Kiosterud]

Duane,

One exposure here is ambiguous first/last name combinations. Jons Mith and
Jon Smith would be equivalent. Probably not a great example, but it's
getting late. I'm trying. You could protect against that with:

d2 = a2 & "*" & b2
=OFFSET(Sheet1!C1,MATCH(A2 & "*" & B2,Sheet1!D24,0),0)

Untested. The asterisk could be any character.

 

[duane]

Ed, good suggestion......