Help creating a Search and Match function that pulls from a specific cell based on a match

Im a basic excel user who needs help creating a formula that is above my knowledge level of excel. Apologies if I use the wrong terms.

I have an excel document with multiple sheets. I need to pull information from other sheets and pull to the main sheet based on information in two different columns.

Example: Sheet 1 cell A12 contains "2016" cell B12 contains "CS1A" cell C12 is an empty cell. I would like to automatically pull info from sheet 2 and add to cell C12. I need the formula to search sheet 2 for the row which contains a cell that contains "2016" and a cell that contains "CS1A" and return the information from the last cell in that row which contains info and return it to sheet 1 cell C12.

Thank you for your help.

Hello and welcome to the forum.

Attach a sample workbook.
Make sure there is just enough data to demonstrate your need.
Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

Ok thanks for the info on uploading. I just added a sample doc.

In this doc I need to search sheet 2 for the row that matches the info in Columns B and C from sheet 1 then pulls the latest cost into the cell in column D

Here's one way that uses a helper column.

Cost Sheet H3 =LOOKUP(2,1/(C3:G3<>""),C3:G3) Drag this formula down through row 14.

Master Sheet D2 =INDEX('Cost sheet'!H$3:H$14,INDEX(MATCH(B2&C2,'Cost sheet'!A$3:A$14&'Cost sheet'!B$3:B$14,0),0)) Drag this formula down through row 13.

Awesome! Wow I spent an hour messing with formulas and you nailed it in minutes. Thank you very much.

My pleasure. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.