I am using an ID col as the Key, and the ref ...

[Tammi_Canelli]

I am using an ID col as the Key, and the ref is the first name col, but then on the referenced sheets instead of first name in that col i get the ID.

Should the ID columns be the reference AND the key?