IF statement, AND & Vlookup on 3 condition that's not in numeric

[JulieB]

Hi,



I read some of the thread in Excel forum mostly explains IF statement, AND & Vlookup when the conditions are numeric. I'm not sure if my request is possible. Would appreciate if someone can advise.

Here's the screen shot and request queries.
2 sheets - Revenue and Summary
Summary worksheet.JPG

Revenue worksheet.JPG

I need to find out the revenue $ [G2] for SAP No [Cell A2] according to Fiscal Period - FY12 Q1 [Cell C2] in Summary sheet from Revenue sheet which contains list of Revenue arranged according to Fiscal Period and SAP No.

I tried IF statement and Vlookup and/or add on AND conditions but not feasible. Appreciate advise there's any alternative solution apart from checking one by one as my data is huge.

Many Thanks!