Hello:

This is my first post!

I'll try not to make this lengthy. Tab 1 contains my formulas, and tab 2 contains my data.

I entered the following formula: =HLOOKUP(A$2,data,2,FALSE)
"A$2" is referencing the column name in tab 2
I named the data in tab 2 "data"

Okay, so if I copy/paste "=HLOOKUP(A$2,data,2,FALSE)" down, it doesn't update the "2" to "3". The same data is being presented. How do I change the formula so it knows to pull each row beneath it in tab 2?
Thanks,

VJ