Forum Discussion
lonnykoons
Apr 10, 2024Copper Contributor
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...
Yea_So
Apr 12, 2024Bronze Contributor
You can share the file without data in it, so the people helping you can see the geography of the solution you are trying to develop, the people can create fictitious dummy data for testing.
lonnykoons
Apr 12, 2024Copper Contributor
Yea_So here is the link to a copy of the file. I tried to do this yesterday but this site was not allowing me to submit the reply with the link. Anyhow, here goes:
https://1drv.ms/x/s!Atgssv4HR3i6ghxJdtdGG3ND3Nmt?e=6ytSxj
- Yea_SoApr 12, 2024Bronze Contributor
Is this ok?
The value in E5 is looking up the value in A6 in the ,$AR$4:$BA$1048576 range?
- lonnykoonsApr 12, 2024Copper ContributorText will not show in D5:L34 unless a choice from the drop down menu in column M is selected.
- lonnykoonsApr 12, 2024Copper ContributorYes, 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.
- Yea_SoApr 12, 2024Bronze Contributor