Find cell that contains a specific character

[xljunkie]

Cells A1:A5 all have a vlookup formula that will pull one of the following into it:
1. The word "NONE"
2. #N/A error since it doesn't exist in the table
3. A text value that has the format 13.55.46.91

I want a formula that will look at these 5 cells and give me #3. That #3 value can only appear once in the 5 cells in any of those 5. The other 4 cells will contain either 1 or 2.

3 always has length equal to 11. It always has periods in those places. The digits do change.

I've tried a bunch of different methods but I can't seem to figure out something that works.

 

[wigi]

For example;

=INDEX(A1:A5,MATCH("*.*",A1:A5,0))

 

[xljunkie]

Perfect thanks.

 

[wigi]

Or if you prefer the good old VLOOKUP:

=VLOOKUP("*.*",A1:A5,1,0)