Conditional Text Formula

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!!

Yay! It worked, thank you!!

---------- Post added at 11:29 AM ---------- Previous post was at 11:24 AM ----------

Quick question, what does the "A,B" represent in the formula? I need to adjust it for other columns.

That's what I thought, but what if I need to it to look in column G for the data. Do I put A,G?

---------- Post added at 11:39 AM ---------- Previous post was at 11:32 AM ----------

Ahhh, OK! that works! thanks so much friends!

Yup, thanks! Now, could I just tell it to look at the whole spreadsheet "A,AI" and to return the column number I want, so say "A,AI,14"?

Thanks again!