Forum

You were so close, Sunny. It's =INDEX($E$20:$F$25,MATCH(K20,$E$20:$E$25,0),2). Thanks for the vital lead!! Donald

I'm getting closer! Based on a suggestion, I concatenated columns A-D and G-J to produce a single column on each side for comparison, labeled as E ...

Hi Sunny, #1 - The actual data is privileged and I should not make it public. #2 - You may be on to something here. I could concatenate columns...