I'm trying to Hlookup a cell but the reference cell is merged. I only receive
information from the first of the two columns underneath the merged reference
cell and not the second - is their a way to change the formula so that I can
recieve both sets of looked up information?