Do you mean that you want a sort of IF(A,F23,G23)?

--
__________________________________
HTH

Bob

"BBAL20" wrote in message
...
I'm looking to write a formula that matches two criteria before
calculating a
forecast. I tried using a IF AND function but the Forecast function itself
will only calculate based on one X value. I want the X value only if it
returns a TRUE matching two criteria in two different columns first. Is
there
a way to calculate this?

Here is my current forecast formula:
=FORECAST(F23,'Raw Data'!$G7:$G50003,'Raw Data'!$O7:$O50003)*F13

I want to do an IF(AND function first to match two values from two
different
columns in my RAW Data worksheet. The problem is that the forecast formula
only looks for one value, but I want to qualify that value based on two
criteria that match first. I hope that is clear enough. Please let me
know.
Thanks