markomarra
New Member
- Joined
- Apr 26, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
To Whom,
In a nutshell.
I have a column of stationing values that I would like to have the searched.
Find the interval between every PC and PT values in the search range and determine if another value is within that interval. If found return another value from a different column.
criteria:
1. PNT Type = "BL"
2. GEO. Type = ONLY the interval between PC and PT
3. BL = BL must Match Baseline
4. GEO. TIE = POT or POC
return value:
1. Radius Length.
Would prefer to use a excel formula. Maybe "xlookup" will work. but, only a suggestion/best guess. But if not possible a macro would suffice also.
Thanks in advance.
Mark
In a nutshell.
I have a column of stationing values that I would like to have the searched.
Find the interval between every PC and PT values in the search range and determine if another value is within that interval. If found return another value from a different column.
criteria:
1. PNT Type = "BL"
2. GEO. Type = ONLY the interval between PC and PT
3. BL = BL must Match Baseline
4. GEO. TIE = POT or POC
return value:
1. Radius Length.
Would prefer to use a excel formula. Maybe "xlookup" will work. but, only a suggestion/best guess. But if not possible a macro would suffice also.
Thanks in advance.
Mark