Hi,
A couple of days ago I posted a request for help with an if statement based on text search (see link at bottom of this post). Some kind posters gave me the solution I needed, which was the following formula:
=IF(ISERROR(IF(ISNUMBER(SEARCH("*",H10490)),MID(H10490,1,FIND("*",H10490)-1),S10490))=TRUE,H10490,IF(ISNUMBER(SEARCH("*",H10490)),MID(H10490,1,FIND("*",H10490)-1),H10490))
However, the problem with this is that the resulting number I get has weird formatting which means I am then unable to carry out a lookup on the number against a list of numbers I have. Does anyone have any thoughts on why this is the case. Even better does anyone have a recommended solution?
Kind regards
HA
P.s. see below for a link to the original request for help:
http://www.excelforum.com/excel-gene...xt-search.html
Bookmarks