I have two worksheets and would like to write a forumla that says if the contents in sheet1 A1 is anywhere in Sheet2 A1:A400 then bring to sheet1 the contents of sheet 2 Column B, specifially the row where columns A match.

If I can not do that, then I would like to say, If sheet1A1 is anywhere in Sheet2 A1:A400 find that row in sheet 2 and in column C of that row put the number 1.

Thank you for your help!

Pat