SOLVED
Data type error
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kinetic_analytics
11 - Bolide
‎12-23-2021
09:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello:
How can I solve it:
=IFERROR((IF(F2=0,0,VLOOKUP(F2,E:N,10,FALSE))),0)
Thanks
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
1 REPLY 1
16 - Nebula
‎12-23-2021
10:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use a Join tool and connect your data to both the L and R inputs. Select Case ID for one dropdown and Related Case as the other dropdown to join by. This should get you pretty much there.
