Hi,
I am trying to make a dispatch note that when you type in the UJN from our project tracker it will pull through the Customer, Plot or Site Information depending on the cell.
I have used this formula on a current spreadsheet to show some delivery info at a glance; =XLOOKUP($A$9,Sheet1!$A:$A,Sheet1!B:B,"") I was hoping that this would work (amended obviously) as it does currently but that runs off of different tabs on the same work book and it doesn't seem to want to work on the new Dispatch Note.
(I can't make XL2BB Work) My Despatch note looks like this:
and an example of the Project tracker from where its drawing the info from is like this: the only information that is Unique is the Job number
So Using the above examples The dispatch note should read Like this:
The amended formula noted on the dispatch note is showing "0" when no information in the Job No Cell but showing an empty cell when I put a job number in as if it's finding the information but suggesting the Project tracker row is empty. (It's not I checked)
I'm sure it is something really straight forward but I've stumped myself. So thought I would ask for the help of you wonderful people before I lose the plot entirely.
TIA
Sarah
I am trying to make a dispatch note that when you type in the UJN from our project tracker it will pull through the Customer, Plot or Site Information depending on the cell.
I have used this formula on a current spreadsheet to show some delivery info at a glance; =XLOOKUP($A$9,Sheet1!$A:$A,Sheet1!B:B,"") I was hoping that this would work (amended obviously) as it does currently but that runs off of different tabs on the same work book and it doesn't seem to want to work on the new Dispatch Note.
(I can't make XL2BB Work) My Despatch note looks like this:
| Job No | Manual Input | Despatch Date | Manual Input |
| Plot No | =XLOOKUP($C$2,'[Project Tracker 2020.xlsx]Live Project Tracker'!$A:$A,'[Project Tracker 2020.xlsx]Live Project Tracker'!$D:$D," ") | Customer | =XLOOKUP($C$2,'[Project Tracker 2020.xlsx]Live Project Tracker'!$A:$A,'[Project Tracker 2020.xlsx]Live Project Tracker'!$B:$B," ") |
| Bed 1 | |||
| Site Address | =XLOOKUP($C$2,'[Project Tracker 2020.xlsx]Live Project Tracker'!$A:$A,'[Project Tracker 2020.xlsx]Live Project Tracker'!$C:$C," ") | Site Contact | Manual Input |
and an example of the Project tracker from where its drawing the info from is like this: the only information that is Unique is the Job number
| Job No. | Customer | Site | Plot | Ali Doors | Timber Doors | Requested Customer Date | Status | Var. | Initial Contract Value | |
| 9505 | Eg 1 | Site Name Example 1 | 1 | |||||||
| 8032 | Example 2 | Site Name Example 2 | 1 | |||||||
| 8033 | Example 2 | Site Name Example 2 | 2 | |||||||
| 8034 | Eg 3 | Site Name Example 3 | 3 | |||||||
| 2313 | Eg 1 | Site Name Example 1 | 64 | |||||||
| 0548 | E2 | Site Name Example 4 | 62 | |||||||
| 0552 | E2 | Site Name Example 4 | 66 |
So Using the above examples The dispatch note should read Like this:
| Job No | 9505 | Despatch Date | TBC |
| Plot No | 1 | Customer | Eg 1 |
| Bed 1 | |||
| Site Address | Site Name Example 1 | Site Contact | TBC |
The amended formula noted on the dispatch note is showing "0" when no information in the Job No Cell but showing an empty cell when I put a job number in as if it's finding the information but suggesting the Project tracker row is empty. (It's not I checked)
I'm sure it is something really straight forward but I've stumped myself. So thought I would ask for the help of you wonderful people before I lose the plot entirely.
TIA
Sarah
