Return the contents of 1 cell based on the contents of another cell

[Squint]

I thought this was a pretty simple formula but I am having difficulty creating it. I am attaching a little test spreadsheet. Sheet 1 is where the data will be entered. The Reimbursed column has a drop down choice of yes or no. The next 2 columns are the cost of registration and the cost of accommodations. On sheet 2 is where I would like the formulas. So in cell A4 I would like a formula that says if B3 on sheet 1 is Yes populate this cell with the contents of Cell C3 only, B4 of sheet 2 would then be B3 if A3 on sheet 3 is Yes and so on with the Not reinbursed if sheet 1 the Reimbursed column is no.

It is just not turning out to be as simple as I thought. I've tried several formulas for the past hour and thought someone here may be able to come up with a solution for me sooner.

Thanks for any assistance!

[alansidman]

Data Range

	A	B	C	D	E	F
1	Reienbursed		Not Reinbursed
2	Accomodation	Registration	Accomodation	Registration
3	61381	61142	61381	61142
4	=IF(Sheet1!A3="Yes",Sheet1!C3,"")	=IF(Sheet1!A3="Yes",Sheet1!B3,"")	=IF(Sheet1!A3="No",Sheet1!C3,"")	=IF(Sheet1!A3="No",Sheet1!B3,"")
5

[Squint]

Thanks so much. Works perfect!

[alansidman]

Thanks for the feedback.