Returning cell value from Table

[nirvehex]

Hey guys,

Quick questions about tables.

I have two worksheets: Recommendations and Services

The header name is "LocationCode"

My Header on the recommendations tab starts in row 2. My header on the services tab starts in row 1. This cannot change.

In row 3 on Recommendations tab I put

=Table2[@[LocationCode]]

. However it is one row off because of the data starts in row 2 on the one tab and row 1 on the other. Is there anyway to subtract a row off of this formula somehow?

Thanks!

 

[nirvehex]

Nevermind...Got it!

=OFFSET(Table2[@LocationCode],-1,0,1,1)