cross check names and return value from other sheet

[florischu]

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