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