H Lookup

[Guest]

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?

 

[Guest]

Probably in this case
an index and match and index and match +1 would work better than Hlookup

=index(data_array,1,data_row,match(lcriteria,lookup_range,matchtype))
=index(data_array,1,data_row,match(criteria,lookup_range,matchtype)+1)