Forum Discussion
Advanced Logical Linking Formulas in Excel
I have regenerated an older tracker that my company uses to track driver loads. My higher headquarters requires redundant reporting so rather than fill out multiple trackers that ask for the same dat...
Is this ok?
The value in E5 is looking up the value in A6 in the ,$AR$4:$BA$1048576 range?
Yes, it pulls a value where we input the load number by our tracking / pay ID and by the tracking / ID that Family Dollar tracks it by. If you scroll further right, you will see the cells it is pulling from.
- I do not track repowered loads; but, as long as there is a status in column M, the load number will populate to the left in D4:J34.
I am not quite sure what you are asking otherwise?You've changed the vlookup formula into xlookup formula and used named ranges however:
The error I was trying to point out before was the vlookup formula
If you notice the vlookup formula is for row 5 but using A6 for the lookup value.