two numbers to one cell

[johnny52]

Let's say I have two numbers in cell A1 (1,1A )

is there a way to construct a formula in B1 something like this =if(a1="1A",if(a1=1,1,""))

unfortunately they have to stay in the same cell.........the cell is used in other parts of a bigger worksheet.

Thanks everybody

 

[Rick Rothstein]

Give this formula a try (I have highlighted the two numbers you are searching for in red (in case you want to change them for other searches)...

=IF(AND(ISNUMBER(SEARCH(","&"1"&",",","&A1&",")),ISNUMBER(SEARCH(","&"1A"&",",","&A1&","))),1,"")

 

[DanteAmor]

I have a doubt, you want the result 1 or the first number of the binomial.

Another option:

=IF(TRIM(SUBSTITUTE(SUBSTITUTE(A1,"A1",""),",",""))="1",1,"")

 

[johnny52]

Works perfectly thanks

 

[Rick Rothstein]

Works perfectly thanks

Just out of curiosity, which formula was the one that worked?

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[johnny52]

I wanted the result 1 Rick's reply did the trick Thanks

 

[johnny52]

Would you mind if I ask you another question I'm having an issue with a vlookup formula that is only returning the first value....I think and index match might work

 

[Scott T]

Vlookup and index match will only return the first result. You can return more by using a index small if formula. Explain what you need and someone can help you.

 

[DanteAmor]

Do you want to obtain several results or a particular result?
Explain with examples what you have and what you expect results.