HLOOKUP

Hello Philip

Thank you for your question and welcome to the forum.

An Hlookup is similar to a Vlookup except that rather than looking vertically down the data range and selecting columns across it looks horizontally and then selects the row.

I've attached an example with an hlookup formula so you can see how it works.

Amanda