Hi!
I’ve got 3 tables:
- 1st with codes and their 4 ordering codes
- 2nd where you type one of the codes from 1st table and it returns its ordering codes (V.LOOKUP)
- 3rd where you get all alternative codes of the chosen one (2nd table) but only with the same first ordering code.
What I’m looking for:
To get list of all alternative codes which ordering codes (one of them) match one of chosen code’s ordering codes.
But only when ordering codes are not equal to ‘nd’ or ‘0’.
Bookmarks