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,looku p_range,matchtype))
=index(data_array,1,data_row,match(criteria,lookup _range,matchtype)+1)


"Ady" wrote:

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?