Look for matching information from two columns in one sheet, in another sheet

I have one sheet that contains three columns of data. I want to look in another sheet and find if any of the rows in that sheet have the same data found in the first sheet.

I have attached an example sheet of what I need done:

In reference to the example, I am first looking in sheet 2. The information from Column A and C is what I want to find in sheet three if it is there. So for example, A1 and C1 are Joe and 233. I want to then look into sheet 3 and see if any row in sheet 3 has Joe in column A and 233 in Column B. if so I want the value in column B (233) returned into a new sheet.

I need this process to repeat for all rows in sheet 2. The number of rows may change in either sheet.

I am not sure where to begin with this one and I would prefer a formula but I think a VBA solution is needed. Any help is much appreciated thanks!

Hi
got the solution..
check the attachment..



Don't forget to click *

I am not sure how to use the spreadsheet, I just get all "1" down the column with the formula in it. I would like to get the value of cell in column B on sheet 2 as the answer, not just a yes or no or a 1 or 0.

Any idea on the formula?