|Read the Excel Help files on HLOOKUP to help you understand how this formula works.|
While VLOOKUP is more commonly used than HLOOKUP they both basically perform the same function. The V stands for Vertical while the H stands for Horizontal.
The key thing to understand is the use of the 1 (or TRUE) as the range_lookup argument which is required since you are not looking for an exact match. (I like to use 1 instead of TRUE simply because it's less typing.)
=HLOOKUP(A1, $A$2:$C$3, 2, 1)
=HLOOKUP(A1, $A$2:$C$3, 2, TRUE)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.