How do I create a formula that searchs 1-cell for a range of numbe

I'm looking to search 1-cell for a range of numbers i.e
I want to enter a formula in cell C-1
if cell A-1 is 16 or 30, I want the formula to provide me the info in
cell B-1. If the criteria is not met, I want to see a null value.

Let me know. Thanks!

=IF(AND(A116,A130),A1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg-B" wrote in message
...
I'm looking to search 1-cell for a range of numbers i.e
I want to enter a formula in cell C-1
if cell A-1 is 16 or 30, I want the formula to provide me the info in
cell B-1. If the criteria is not met, I want to see a null value.

Let me know. Thanks!

Thanks Bob. I was missing the second A1 entry for the 30! This eleviated
my 2 hours of torture trying to figure this out.

"Bob Phillips" wrote:

=IF(AND(A116,A130),A1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg-B" wrote in message
...
I'm looking to search 1-cell for a range of numbers i.e
I want to enter a formula in cell C-1
if cell A-1 is 16 or 30, I want the formula to provide me the info in
cell B-1. If the criteria is not met, I want to see a null value.

Let me know. Thanks!

Glad to be of service.

Bob

"Greg Bobak" Greg wrote in message
news
Thanks Bob. I was missing the second A1 entry for the 30! This
eleviated
my 2 hours of torture trying to figure this out.

"Bob Phillips" wrote:

=IF(AND(A116,A130),A1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg-B" wrote in message
...
I'm looking to search 1-cell for a range of numbers i.e
I want to enter a formula in cell C-1
if cell A-1 is 16 or 30, I want the formula to provide me the info
in
cell B-1. If the criteria is not met, I want to see a null value.

Let me know. Thanks!