5 pts.
 Excel function to identify combination of text and numbers
I have a list of IDs (for example NSD2015, 751234, 92231J,V1819, GR5007 etc.)and would like to identify those from a list of thousands of IDs (each in a separate row in the same column). Tried VLookup but it appears that only works with values? Getting frustrated and I'm sure this is easy to do... just can't find which function to use. Thanks in advance!

Software/Hardware used:
Excel 2010
ASKED: February 14, 2013  4:06 PM
UPDATED: February 14, 2013  4:15 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,390 pts. , topdrawer   5 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _