Get an Absolute Sheet Reference in an IF statement

[icarrington]

=IF(F6="Management",SectionData!$C$7,"")=IF(F6="Accounts",SectionData!$C$6,"")=IF(F6="Manufacture",SectionData!$C$8,"")=IF(F6="Sales",SectionData!$C$9,"")

That's my statement, and it's not working. What it's supposed to do is if the cell F6 in the sheet "Staff" says "Management", it's supposed to collect the data from cell C7 in the sheet "SectionData". If F6 says "Accounts", then the cell should display data from cell C6 in the sheet "SectionData". What am I doing wrong?
Oh, and the sheet reference has to be absolute.

I'm new to Excel.

[Teethless mama]

=VLOOKUP(F6,'Section Data'!$B$6:$C$9,2,0)

[icarrington]

When there is no data in F6, how do I make it display nothing instead of #N/A?

[Teethless mama]

=iferror(VLOOKUP(F6,'Section Data'!$B$6:$C$9,2,0),"")

[Ace_XL]

=IF(f6="","",VLOOKUP(F6,'Section Data'!$B$6:$C$9,2,0))

[icarrington]

When I enter both of those formulas, a save file thing comes up.