=OFFSET(Sheet2!$B$1,MATCH(Sheet1!L1,Sheet2!$A$1:$A $200,)-1,)


On 16 Kwi, 21:24, SBW wrote:
Is there a function I can use to ....

- Check if Sheet 1 L1 value is listed anywhere in Sheet 2 Col A. *If true,
then return the corresponding value from Sheet 2 Col B into the corresponding
cell in Sheet 1 Col M.

Sheet 1:
* * * * * A....K * * * * * * *L * * * * * * M
1 * * * * * * * * * * * * Part 1 * * * * *
2 * * * * * * * * * * * * Part 2 * * * * *
3 * * * * * * * * * * * * Part 3 * * * * 4/16/2009

Sheet 2:
* * * * *A * * * * * * * *B
1 * *Part 3 * * * * *4/16/2009
2 * *Part 4 * * * * *
3 * *Part 5 * * * * *4/17/2009