Hi Marvin and TMS,
I finally found the thread I was referring too, so after finding the thread and a good nights sleep...TMS, you were right on for what I was seeking.
=CHOOSE(MATCH(G2,I1:K1,0),DV_CIV,DV_CME,DV_MIL)
Thanks again to both of you for your help and interest![]()
Bookmarks