If a number exists as part of the cell, Then

[Redwolfx]

Perhaps I'm making this more difficult than I need to.


I have a list of names generated by my system.

I'm doing a simple Vlookup to pull the names based off their ID in another sheet.

Some of the names start with a code X90 or U48 amonst others.

If the first three characters contain a number I'd like the cell to be blank.

Current Formula =IFERROR(VLOOKUP($E2,Sheet1!$A$2:$C$10000,2,FALSE),"")

 

[exceldevs]

Hi Red,

Try this.
=IF(SUM(--(ISNUMBER(VALUE(MID($E2,{1,2,3},1)))))=0,IFERROR(VLOOKUP($E2,Sheet1!$A$2:$C$10000,2,FALSE),""),"")

 

[Redwolfx]

Thanks for the quick response. I've been working on it as well.

I actually got it working slightly differently

=IF(ISNUMBER(LOOKUP(99^99,SEARCH({0,1,2,3,4,5,6,7,8,9},E2))),"",IFERROR(VLOOKUP($E2,Sheet1!$A$2:$C$10000,2,FALSE),""))

 

[exceldevs]

You're welcome, nice formula!