Hi, I have an issue where my HLOOKUP lookup_value is pointing to another cell that is also using a HLOOKUP ... it returns a #N/A but if I remove the HLOOKUP from the lookup_value cell and replace it with a value, it works.

Here's my formula that won't work: =HLOOKUP(G17,D32:K38,7,FALSE)
Here's what is in G17: =HLOOKUP(G16,'MSW Production'!C17:J21,2,FALSE)

I have tried putting a *1 at the end to see if it was a translation of text to numeric, but it didn't do anything.

Any help is appreciated.