finding cell value(s)

B

Bob Mc

Can someone give me some direction on how to do the following:

I have 32 cells containing numerical values. These numerical values vary
from, say, 52 to 338. These cells are not necessarily in a range. Using
another formula, I'd like to find only the cells that contain values
"between 72 and 86" and end up with a cell value in the same column(s) as
the "between 72 and 86".

I've tried various combinations of IF, AND, LOOKUP, VLOOKUP, HLOOKUP,
CHOOSE, etc.

Thanks for any help,
Bob Mc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top