Hlookup on a returned number

Evening all,

I have a table of data

I have a list of the top 5 largest numbers:

=LARGE($AM$129:$BJ$129,1)

These returned numbers are for example 531.32

A title represents that number which I'm trying to lookup and have returned.

However I seem to be unable to for some reason.

I can get the Vlookup function to work but the Hlookup won't which I'm confused about...

=HLOOKUP(AW81,AM129:BJ129,3,)
It returns #REF!
=VLOOKUP(AW81,AM94:BJ129,3)
Returns a number a few away from 531.32....

Any ideas why the Hlookup won't work the same way?

Cheers all

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi

a first step

=HLOOKUP(AW81,AM129:BJ129,3,)

would need at least 3 rows to read

=HLOOKUP(AW81,AM129:BJ131,3,)

Regards

In G2, copied down:

=INDEX($C$54:$Z$54,MATCH(H2,$C$52:$Z$52,0))

You're welcome...