Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=IF
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|