Template column from one sheet as lookup value in another?

[mthakershi]

I have a template column in “Payments” sheet. I want to pull it in “Home” sheet as a lookup value. But it won’t show in the menu. Please see two screenshots.

Thanks.

[Gerard_Fernandez]

is it a single or multiple relation? Should be single for lookup

[mthakershi]

Single relation.

[david]

I think you want to use Single Value for this.

[Jeff_Hager]

I tried this out and it seems to work for me. I created a template in my second sheet. In my first sheet I created a relation column to the second sheet and a lookup column. I was able to select the template column. Has this been fixed for you?