I am using Excel 2003.
I have Spreadsheet#1 which has Names and Dates in columns as below.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
A B
Name | Date
<o> </o>
I have Spreadsheet#2 which contains Date, Sales and Results for each Name as below and is exported from a database in this format.
<o> </o>
A B C D E F
Name Name
Date | Sales | Results | Date | Sales | Results
<o> </o>
In Spreadsheet #2, the I have tried writing an array formula in the Results column to enter the value from the Sales column into the Results column if the Name in cell A1 equals the Name in column A of Spreadsheet#1 and the Date equals the Date in Spreadsheet#1. When the array formula returns a false result (name and date do not match), the formula returns zero as the answer. Is there a way I can have a blank result for false? The reason I need a blank is because I am graphing the data in Spreadsheet#2 and I don’t want all the false results (the zeros) appearing on my graph.
I have looked at several sites online and have not been able to find a solution. Any help would be appreciated.
Thankyou!!
I have Spreadsheet#1 which has Names and Dates in columns as below.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
A B
Name | Date
<o> </o>
I have Spreadsheet#2 which contains Date, Sales and Results for each Name as below and is exported from a database in this format.
<o> </o>
A B C D E F
Name Name
Date | Sales | Results | Date | Sales | Results
<o> </o>
In Spreadsheet #2, the I have tried writing an array formula in the Results column to enter the value from the Sales column into the Results column if the Name in cell A1 equals the Name in column A of Spreadsheet#1 and the Date equals the Date in Spreadsheet#1. When the array formula returns a false result (name and date do not match), the formula returns zero as the answer. Is there a way I can have a blank result for false? The reason I need a blank is because I am graphing the data in Spreadsheet#2 and I don’t want all the false results (the zeros) appearing on my graph.
I have looked at several sites online and have not been able to find a solution. Any help would be appreciated.
Thankyou!!