Mar 4, 2021
10:03:51pm
10:03:51pm
This put me on the right track. I ended up using the following conditional
format rule to get this working. Thankfully I only had two prefix lengths (6 and 7):
=OR(NOT(ISNA(VLOOKUP(LEFT(F1,6),'Special Comp'!A:A,1,FALSE))),NOT(ISNA(VLOOKUP(LEFT(F1,7),'Special Comp'!A:A,1,FALSE))))
Thanks everybody!
=OR(NOT(ISNA(VLOOKUP(LEFT(F1,6),'Special Comp'!A:A,1,FALSE))),NOT(ISNA(VLOOKUP(LEFT(F1,7),'Special Comp'!A:A,1,FALSE))))
Thanks everybody!
- Previous username
- patentattycoug
- Bio page
- David Lo Pan
- Joined
- Jul 14, 2011
- Last login
- Jun 8, 2024
- Total posts
- 1,930 (6 FO)
Messages
Time
3/4/21 10:33am
3/4/21 11:04am
3/4/21 11:20am
3/4/21 11:37am
3/4/21 3:04pm