Return the correct value that matches criteria

[GMC The Macro Man]

Hello everyone,

I need to return a value based on it's criteria from 1 of 2 data sheets.
In the "REPORT" tab on the attached spreadsheet, I need cell "D3" to return a Value based on the Region.
If the Region equals "North" or "South", then I want to return the value in "C2" from DATA 1 tab.
If the region equals "East" or "West", then I want to return the value in "C2" form DATA 2 tab
Is there an easy formula for this?
TIA
GMC

Book1
	A	B	C	D
1
2		Month	Region	Sales
3		July	North
4
Report

Book1
	A	B	C
1	Code	Region	Sales
2	Data 1	North	£250,000
Data 1

Book1
	A	B	C
1	Name	Region	Sales
2	Data 2	West	£300,000
3
Data 2

 

[dreid1011]

Maybe something like this:

=IF(OR(C3="North",C3="South"),'Data 1'!C2,'Data 2'!C2)

 

[GMC The Macro Man]

Maybe something like this:

=IF(OR(C3="North",C3="South"),'Data 1'!C2,'Data 2'!C2)

This looks good bud. It's what I was thinking but i just didn't know how to write the formula.
Many thanks

 

[dreid1011]

This looks good bud. It's what I was thinking but i just didn't know how to write the formula.
Many thanks

You're welcome, and happy to help.