Lookup Function

Wasdell · Apr 16, 2009

I am trying to lookup an exact text cell and convert it to a numeric value eg

If cell x3 = A15C then the answer will be 15

Teethless mama · Apr 16, 2009

=IF(X3="A15C",15,"")

klswvu · Apr 16, 2009

Microsoft has an excellent article on doing this woth and Array Formula

Extracting numbers from alphanumeric strings
http://office.microsoft.com/en-us/excel/HA011549011033.aspx

How to look up 2 Cell Values	9	Mar 23, 2009
Newbie Help - IF Yes No Function	0	Jan 26, 2022
Function or Sub to help with text string	5	Jun 11, 2013
LOOKUP function	3	Mar 9, 2011
How to replace text with numbers? (formula)	4	Jul 21, 2013
lookup	2	May 20, 2009
Lookup Function help	1	Apr 15, 2012
correcting #value! problem	4	May 24, 2012

Ask a Question