Hi
I have an excel sheet with Data like below
Every week I run the same report and need to update the notes section if the order doesnt exist already in previous sheet
So in sheet 2 I have exact same Header row but data may be different.
I want to be able to compare the 2 sheets and if the order number in Sheet 2 Column B matches the order number in Sheet 1 Column A that it then enters the corresponding notes from Sheet 1 into Cell F ( Notes)
So for the example above it should compare the order umber colums and return the value " Partial Delivery into F1
Any help would be greatly appreciated
I have an excel sheet with Data like below
Order Date | Order No | Name | Delivery Date | Due | Notes |
05/03/2020 | 111 | Mr A | 04/05/2020 | 20 | Partial Delivery |
06/06/2020 | 112 | Mr B | 06/08/2020 | 30 | bal outstanding |
05/03/2020 | 113 | Mr C | 30/03/2020 | 40 | Partial Delivery |
Every week I run the same report and need to update the notes section if the order doesnt exist already in previous sheet
So in sheet 2 I have exact same Header row but data may be different.
I want to be able to compare the 2 sheets and if the order number in Sheet 2 Column B matches the order number in Sheet 1 Column A that it then enters the corresponding notes from Sheet 1 into Cell F ( Notes)
Order Date | Order No | Name | Delivery Date | Due | Notes |
05/03/2020 | 111 | Mr A | 04/05/2020 | 20 | Partial Delivery |
05/06/2020 | 116 | Mr F | 06/08/2020 | 30 | |
05/03/2020 | 120 | Mr G | 30/03/2020 | 40 |
So for the example above it should compare the order umber colums and return the value " Partial Delivery into F1
Any help would be greatly appreciated