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

 

[johnny52]

Hey Rick,yours worked....the other one didn't work for me

 

[johnny52]

Thanks Dante....I was able to use this one

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

 

[DanteAmor]

Thanks Dante....I was able to use this one

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

The formula that I put works for me, maybe if you put exactly what data contains cell A1, I can fix it.

If you have 1, A1 the formula works

 

[DanteAmor]

About this:

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

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