=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 |
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 |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com