Hello,
I'm trying to get this to work. I tried the vlookup, combination of Match & Index, but none helped me to achieve the desired output. I'm missing something.
Here is my lookup table1 with "Holiday" details in the third column. Instead of "Holiday", the column might contains other...