Need to pull data from different tabs using various criteria

[TriinTomingas]

I got stuck creating a formula to pull information from a different tab:

I need the following criteria:
* If payment method is Cash pull the amount in Column G from Sheet 2;
* If payment method is Credit Card mark zero;
* If payment method is Cash but invoice isn't received yet, mark $5,000 // Forecast.

Please see attached an excel file. Thank you

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.