How to ignore prefix


Hello, I have a working formula right now =IFERROR(VLOOKUP(C23,Sheet2!A:B,2,0), "") but there is a problem, sheet2!A contains prefixes like FV FA etc... I want to be able to ignore the prefix. for example column I want to type FV344567 and get a P5 return but the source sheet has F%344567 since the 2nd letter varies. I want to be able to type FV and then then umber and still get the return from column B


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!