FuzzyHLookup not returning a text value?

[CRH]

So I'm using FuzzyHLookup (and thanks a lot to all who contributed to the FuzzyLookups - they're awesome) and instead of returning the value contained in the closest matched field it is returning a number corresponding to the position of that field in the row.

My formula is...
=fuzzyhlookup(D2,I2:AI2,0,35%,1,3)

...and I'm using the macro just as it is in this post...
http://www.mrexcel.com/forum/showpost.php?p=1758415&postcount=43

So I have fields I2:AI2 and I want it to return the closest matching text to that contained in D2, but instead it's returning numbers. If, for example, the best match was in field I2 (the first in the array), it would return 1. If the best match was in J2, it would return 2. It would return 3 if the best match was K2, etc, etc...

I can't flip my data around and use FuzzyVLookup as I have FAR too many rows of data (1000s).

Any ideas?

Thanks!
-Carlton

 

[CRH]

So I ended up just using an =INDIRECT in conjunction with an =ADDRESS to call the data in the corresponding field. Thanks to anyone who may have put some thought into this.

Cheers,
-C