Vlookup and/or conditional formatting

[TheStuff]

Here is my data (everything is in row 1)

Column A "11041220490"
Column B "z9"
Column C


I would like one of two results (the first example is my preference)

First example
if B1 = "z9" then the 5th and 6th digits in A1 turn red

yielded result for first example
Column A "11041220490"
Column B " z9"
Column C

Second example
if B1 = "z9" then place the 5th and 6th digits from A1 in C1

Yielded result for second example
Column A "11041220490"
Column B "z9"
Column C "12"

thanks in advance

 

[Jonmo1]

Example 2 is most reasonable...

In C1, put
=IF(B1="z9", MID(A1,5,2),"")


Hope that helps.

 

[TheStuff]

Thanks, I was killing myself using vlookup. completely forgot about the "mid"

awesome thank you.