Forum Discussion
Need to pull data from different tabs using various criteria
I got stuck creating a formula to pull information from different tab: I need the following criteria: *If payment method is Cash pull the amount in Column G from Sheet 2 and, *If payment method is...
I may have misunderstood what you need, but in E2 you should write simply:
=IF(AND(I2="PENDING";J2="Cash");"5000 $ // Forecast";IF(J2="cash";G2;IF(J2="credit card";0;"")))
You should check first the most strict rule (cash+pending), then cash only or credit card only.
Then you just refer to each month on the summary table...