Advance filter; referencing a cell outside of the list range

[123bob123]

I have an advance filter which works perfectly if I use this formula =AND(J16>=0.607,J16<=0.627)
I does not work if I us this formula =AND(J16>=O6,J16<=P6)

O6 and P6 are not in the List or Criteria range.
O6 contains a formula that return 0.607 and P6 contains a formula that returns 0.627.
So the problem is if I use the actual value the advance filer works and if reference a cell containing the same value it doesn't.

 

[jim may]

What happens if you modify your formula to:
=AND(J16>=INDIRECT(O6),J16<=INDIRECT(P6))

 

[123bob123]

What happens if you modify your formula to:
=AND(J16>=INDIRECT(O6),J16<=INDIRECT(P6))

As soon as the formula is entered I get a #REF ! error.
I still tried to run the advance filter just as a test and it didn't work

 

[jim may]

Does Enclosing O6 and P6 in Double-Quotes make any difference?

=INDIRECT("O6"),J16<=INDIRECT("P6"))

 

[123bob123]

Jim,
This works great, exactly as needed!
I tried different ways to enter the formula but would have never figured this out.
Again, really appreciated, works perfectly.