ExcelBanter - Lookup Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lookup Function (https://www.excelbanter.com/excel-worksheet-functions/227892-lookup-function.html)

Wasdell

Lookup Function

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

Lookup Function

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

"Wasdell" wrote:

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

klswvu[_2_]

Lookup Function

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

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

All times are GMT +1. The time now is 01:22 PM.