How to find if the content in a cell is between the values of 2 different cells.

[Joe11]

Hi, I have an excel worksheet; in that worksheet contains a column. Each cell in that column holds different kinds of data, it looks like this...

column1 from first spreadsheet
22853
33901
0045T
90750
etc, etc...

I have another excel worksheet that has two columns, it looks like this...

column1 from 2nd spreadsheet column2 from 2nd spreadsheet
G0389 null
59840 59857
0040T 0080T
90750 null
4560 5000
etc, etc... etc, etc...

How do I find if a value from a cell from the column from the first spreadsheet is in the range of the values of column1 and column2 from the second spreadsheet? For instance value 0045T is between 0040T and 0080T and
90750 is between 90750 and null. Thank you

[Phuocam]

Try this ...

=OR(COUNTIF(Sheet2!$A$1:$A$5,Sheet1!A1),COUNTIFS(Sheet2!$A$1:$A$5,"<="&Sheet1!A1,Sheet2!$B$1:$B$5,">="&Sheet1!A1))

[Joe11]

Thank you so much for your help. It worked.

[FDibbins]

I knew I had seen this before.
x-posted here
http://www.mrexcel.com/forum/excel-q...ent-cells.html