COLUMN help

[fenpark15]

It's difficult for me to explain why, but what I need is to nest an HLOOKUP inside of a COLUMN function. I have the HLOOKUP set up so that the row it displays has (B2, C2, D2, etc.) entered in those cells. What I want is to nest this HLOOKUP inside a COLUMN so that the result of the HLOOKUP (B2 or whatever) is recognized as the [reference] for the COLUMN and the overall result would be an integer representing that column (i.e. for B2, 2; for C2, 3, etc.). For some reason, Excel will perform the HLOOKUP fine, but when I put the COLUMN around it, it gives me the error message. This is what I have:

=COLUMN(HLOOKUP(B4,'TMR Data'!A1:I2,2,FALSE))

As I said before, the HLOOKUP portion works fine without the COLUMN around it. What could I be doing wrong?

Thanks for your help!

 

[Brian from Maui]

If I understand correctly, replace the row to return (2) with Column() or Row()

 

[fenpark15]

Wow...I was making that way harder than it needed to be. Thanks a lot.