Very bad simple question for #value error

[Distantcrowd240]

Hello All,

I'm hoping that this is a simple question for everyone but it has absolutely stopped me in my tracks.

I have a form that i am trying to pull data from a second page and I am getting #value errors when I use a formula to pull the data.

I use ='CUSTOMER INFORMATION'!C12:G12 to pull a Customer name from one page to all other pages but the pages all display #value

I have made all of the pages format types match as general and I have even tried to make both match as text but I haven't had any luck.

Please help I'm sure it is a simple mistake that I am just missing but any help would be greatly appreciated.



Thank you in advance,
DistantCrowd240

 

[RoryA]

Welcome to the forum.

If you are just pulling a customer name you should only need one cell in the reference: ='CUSTOMER INFORMATION'!C12

 

[Distantcrowd240]

I cant believe that it was that easy but it worked! Thank you so very much for your help