Help! Possible If/Then scenario

[rmrossetti]

Hello! I am currently working on a work book to calculate Full time Equivalent needs vs our margin an revenue targets. I want to keep my workbook as clean as possible to present to upper management, so i am doing my calculations on another tab. I am looking for a way to pull in my direct cost associated with a position on another tab (Tab 2) if a cell I am using on my current tab ( Tab 1 )is populated. So if Cell D2 Has a value in it, the margin on tab2 should calculate based on the position title. That cost from Tab 2 would then have to pull into Cell B2 on tab 1, along with a current sumif formula. This is my second posts, So i am learning the proper tecnique to post example questoins. Any advice on that would be appreciated also. Thank you!

Header	Header
A2	B2

<tbody>
</tbody>

Header	Header
Position Title	D2

<tbody>
</tbody>