Quote:
Originally Posted by 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
Attachment 4023
Attachment 4024
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! |
I'm sure one of the others will have a more sensible answer
However try this
Summarise the data in Revenue as there are two lines for 1000730 for FY12 Q1
Then as a workaround, this is where the experts will shone, use in G2
=IF(ISNA(VLOOKUP(A2&C2&"Total",Revenue!$D$1:$F$39, 3,FALSE)),0,VLOOKUP(A2&C2&"Total",Revenue!$D$1:$F$ 39,3,FALSE))
and copy down.
Gives the correct answer