Excel 2007 : Need help combining vlookup with IF

hi Excel gurus, I know there must be a thread like this out there but I don't seem to be able to find it.... I have a list of projects and activities that saying if they are active or inactive. I want to created a new tab that will do the vlookup of the project + activity, and give me a value of Y or N. For example:
Project: Status: Activity: Status:
1 Y A Y
2 N B Y
3 N C N
4 Y D N

If project = 3, activity = A, it'll be inactive so the column will show me N as result.
If project = 1, activity = B, it'll be active, and it'll show me Y as result.

please help!

Hi Milkie,

Can you attach an example spreadsheet with some comments of the whereabouts, so I can try to find a fix


Thanks,

Bonny Tycoon




**If I was able to help please click the small star icon at the bottom left of my post **

Thanks Bonny,please see attachment of the example.