Hi guys,
I have this working formula:
=IFERROR(INDEX(R9:R6404,MATCH(1,(V9:V6404=D4)*(Q9:Q6404=D6),0)),"")
Producing a string of characters such as:
CSFS2I04
CSFS1I04
The fourth character from the right will either be a 1 or a 2, always. It will be the fourth character from the right, always.
If it is a 2, I want the function to replace it with a 1. Can someone think of a way to make that happen?
Thanks!
Bookmarks