Using a range of values in an IF function

[GenericPat]

Hello everyone,

I'm looking for a formula that will use a RANGE of values (ex: anything between 1000 and 1999) to finalize the IF function...

Example:

IF any cells in column B are between this range, bring this cell and adjacent cell to other sheet...

Example:

In cell A1 I have 1500 and cell B1 I have 2020

I want cells A1 and cells B1 to be copied to another worksheet because A1 is *greater then 1000 and smaller then 1999...

Any help?

Pat.

[ajm123456789]

=IF(AND(A1>1000, A1<1999), A1, " ")

put that formula where u want the output and drag across

[GenericPat]

Can I put somehow instead of IF A1... I would want to put IF A1:A5650

Like instead of looking just in A1 look for any value in range A1:A5650 and return ALL cells who are true?

[ajm123456789]

for that u will need a macro. try posting the question on the vba forum.
a simpler way of doing it would be to filter your data and do a number filter