Thread: IF statement, AND & Vlookup on 3 condition that's not in numeric
View Single Post
 
Old 01-03-2014, 01:56 AM
JulieB JulieB is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jan 2014
Posts: 6
JulieB is on a distinguished road
Default IF statement, AND & Vlookup on 3 condition that's not in numeric
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!
Reply With Quote