Lookup functions

[danielstone121]

Hey guys-

Okay, so I have a workbook and I am trying to pull information from one tab into another tab. However, the information that I need is in column C of the tab I'm pulling from, not column A. Can I do that?

Specifically, I am pulling from a Tab named "SI PW". I am pulling from column C. I am looking for information that is in this form: 99999999@nml. What I would like to do is have a function that will specifically search for the numbers only (so could I use wild cards for the @ symbol and "nml"?).

Thanks in advance!

 

[Jubjab]

What is the expected result? The number of cells with that number in them? A list of the values in those cells? Something else?