Using Excel 2010 and it's new to me...

I am building a summary sheet, and I need to copy text from Sheet2 to my summary.

I need a formula to look at Sheet2 for the name of a company in column A then it returns a start date listed for that company in on sheet2 in Column B.

Side note, at some point Sheet2 may get sorted (column order will not change), so I need the formula to match the company name and pull the appropriate date cell for that company no matter where it is in the sheet.

I know I've done this before, but I cannot remember it! Any help much appreciated!!