I have two sheets. Sheet2 column A has rows of continuous dates from 1992 to current and then columns with weather data (Temp, RH, Wind Speed) per date row. Sheet1 column A has rows of date from 1992 however some of these dates are missing and some have duplicates. Sheet1 then has unique value rows (Cause, Size).
On sheet1 I want to add the Temp, RH, and Wind Speed Columns and then populate the rows using a formula that will match the date. So if the Date in Sheet1 column A matches the Date in Sheet2 column A then the Temp is ___). Hope this is clear, I really appreciate the help and formula!
<TBODY>
</TBODY>
<TBODY>
</TBODY>
On sheet1 I want to add the Temp, RH, and Wind Speed Columns and then populate the rows using a formula that will match the date. So if the Date in Sheet1 column A matches the Date in Sheet2 column A then the Temp is ___). Hope this is clear, I really appreciate the help and formula!
| Sheet1 | Temp | RH | |||
| Date | Size | Cause | Name | ||
| 01/02/1992 | 10 | 1 | Jones | 78 | 22 |
| 01/04/1992 | .25 | 7 | Struggle | ||
| 01/13/1992 | 3 | 6 | Swamp |
<TBODY>
</TBODY>
| Sheet2 | |||
| Date | Temp | RH | Precip |
| 01/01/1992 | 86 | 23 | .05 |
| 01/02/1992 | 78 | 22 | 0 |
| 01/03/1992 | 77 | 26 | .25 |
<TBODY>
</TBODY>
