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!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Header[/TD]
[TD]Header[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]B2[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]Header[/TD]
[TD]Header[/TD]
[/TR]
[TR]
[TD]Position Title[/TD]
[TD]D2[/TD]
[/TR]
</tbody>[/TABLE]