I think what you want to use is
=IF('Rep & Store Name Dump'!A1=A1,'Rep & Store Name Dump'!D1,"")
assuming that sheet 1 is Rep & Store Name Dump

and you want to return the info to shhet 2

"Jim" wrote:

Hello and thanks for the help,

On sheet one I have the following:
A B C D
E
Store1.com IDL Existing Bedroom and Kids Bedroom
Store2.com IDL New Bedroom and Kids Bedroom
Store3.com IDL New Bedroom and Kids Bedroom
Store4.com IDL Existing Bedroom and Kids Bedroom

On sheet 2 I have links to sheet one that fills in the data from the A
column (because the data from sheet one, column A changes):
Store1.com (='Rep & Store Name Dump'!A1)
Store2.com (='Rep & Store Name Dump'!A2)
Store3.com (='Rep & Store Name Dump'!A3)
Store4.com (='Rep & Store Name Dump'!A3)

What I need to do is bring over information from column D if the store name
matches the A column on sheet two.

I am using the following formula:
=IF('Rep & Store Name Dump'!A1,A1,'Rep & Store Name Dump'!A1)

but I am receiving a Value error.

Any help on how to write this formula, when the if is a formula?

Thanks