cross check names and return value from other sheet

**florischu** · 10-04-2008, 04:04 PM

Hi again.

Okay I have a complicated one. I have two sheets. On one I have a list of times on column a and corrisponding names on column b. The second sheet has the list of alphabetical names. I'd like the column beside it to check the name beside it and find that name in sheet one. Then it should return the value from that same row in column a.

For example:
Sheet 1 - cell C4 says '9am - 5pm'; beside it cell D4 says 'Peter'.
Sheet 2 - cell A1 says 'Peter'; cell B1 finds that name in sheet 1 (D1) and checks that same row but column C - so it returns the value '9am - 5pm'.

Is this possible.

As always, thank you kindly.

Florian

**rylo** · 10-04-2008, 10:00 PM

Florian

You can do this with functions.

=INDEX(Sheet2!C:C,MATCH(Sheet1!A1,Sheet2!D:D,0))

HTH

rylo

**florischu** · 10-28-2008, 12:43 AM

That does it, thank you.

Except, the cell is only meant to look for the second occurance of each name. But if the name only appears once, the cell returns that value instead. I need it to return no value, or a TRUE/FALSE, #N/A or zero value instead if there is no second occurrence.

Do-able?

**rylo** · 10-28-2008, 01:13 AM

Hi

Got me confused. Can you attach an example file that shows your various scenarios, what should be returned for each of the scenarios, and an explanation on why that value was returned.

rylo