Combining Mid and If formula

I want the result to be in Colum C

If the "text" in colum A is "ZECH150" then i want that he searches a "=mid(B2;39;3)" in colum B, and the result Colum C


I'm not an excel expert, i have medium experience but want to learn more and more..

This in C2 ...??


=IF(A2= "ZECH150"MID(B2;39;3),"****")


**** what is result if no match ???

Just a slight correction to John's formula to account for your regional settings:

=IF(A2="ZECH150";MID(B2;39;3);"****")

Hope this helps.

Pete

Originally Posted by JohnTopley

This in C2 ...??


=IF(A2= "ZECH150"MID(B2;39;3),"****")


**** what is result if no match ???

yes in c2
if there is no match result can be empty