#value error - please help!

[punkyb]

Please help! I can't get this figured out to save my life!! Please see the attached. All I am trying to do is to get the Customer page to copy the information from the Prospective Customer page. I am entering the following formula ='Prospective Customer'!C2:E2 and all that comes back is #VALUE. I have tried trouble shooting and can't figure it out. Please help, thanks in advance so much!

[ajryan88]

Hi,

You are close. Just change the formula to

='Prospective Customer'!C2

and drag it down. When dealing with merged cells, you only need to refer to the upper-left most cell.

I hope this helps

[punkyb]

Thank you sooooo much!!!!

[ajryan88]

You're welcome.

Please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks