Forum Discussion
Any formula for cartesian coordinates applicable to building construction?
In a building plan drawing, it contains gridlines in X & Y directions. Taking a drawing as an example, gridlines A to F in X direction and gridline 1 to 6 in Y direction. Gridline B is 1000 offset fr...
- Xlookup is the best, maybe I rename the 1 to 12 to small capital alphabet.
youngken Not sure what you mean. And perhaps you should not mark your own follow-up question as the "best answer".
If a drawing as an example, gridlines A to F in X direction and gridline 1 to 12 in Y direction. If it possible to find a solution?
youngken Well, I guess you can extend the Y direction to how many lines you want. Just follow the logic in either of the formulae I suggested. Which one works best for you? XLOOKUP, LOOKUP or MATCH?
- Xlookup is the best, maybe I rename the 1 to 12 to small capital alphabet.
