Hi

I need a formula that will reference a specific value located in A1:A1000 on worksheet 1, locate the same value in A1:A1000 on worksheet 2 and return the value from Column C on worksheet 2 for the same record.

I've done this before, a long time ago, and can't recall now. Any help appreciated.