Excel - reference 1 worksheet & populate another worksheet

[camster39]

I have 2 worksheets, 'Final list' and 'NJ List'. There are 3 columns in 'Final List' that are not yet populated with data. They are 'email', 'phone' and 'title'.

I want to reference NJ List and if there is a match for first and last name (which are contained in both lists in columns A & B respectively), then I want to populate 'email, phone & title' with the corresonding value from the worksheet titled "NJ List".

What would the formula be for the cells that I'm looking to populate?

Thank you.

 

[SkipVought]

Hi,

Easiest thing to do is make another column in each table that concatenats the first & last names.

The the formula is of the form...
[tt]
=INDEX(emailRange,MATCH(newcolumnCellref,othernewcolumnrefRange,0),1
[/tt]
I suggest using named ranges.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]