hi, i have a IF formula.

=IF(AND($C175="product A",AND($F175>=39448,$F175<=39532)),$J175,0)

were i have highlighted in red, rather than it looking directly at the cell reference in question as it is now. i'd like it to look at 2 cells: i.e. cell A would have the letter C in it and cell B2 going downwards would have the range 175 to 185 going down the column.


now, i thought something like: $B1,B2= would work, but i cant get it too.
can any1 give me support please?

This works in a brief test:

=IF(B145&C145="C99","yes", "no")

Where 1 cell had C and the other had 99.

What do you mean by "going down the column" ?
Do you want to test ALL of these values ?

helicopter,

im going to put this formula on hold for the short term, something else has come up, (new post)