Lookup value in other sheet - return coresponding value

[SalmatMikeG]

Hi,
I need to :
- Take a value on the same row as the formula
- Look-up that value on another workbook / worksheet
- Return a value in on the same row as the value in the other sheet

Can this be done ?

Regards
Michael Green

[daddylonglegs]

Sounds like VLOOKUP or INDEX/MATCH

If you want to lookup C2 in sheet2 column A and return the corresponding value from column B

=VLOOKUP(C2,sheet2!A1:B100,2,0)

The 2 indicates the column number of the range from which to return the value, see Excel help

or where the value you want to return is from a column to the left, i.e. you want to lookup the value in column B and return a value from A

=INDEX(sheet2!A1:A100,MATCH(C2,sheet2!B1:B100,0))