Skip to Main Content

Help for rule design to replace VLOOKUP

Kiran_Jun 4 2019 — edited Jun 7 2019

Hello everyone,

I am currently implementing EPBCS at a professional services firm to replace their existing Excel heavy solution. Given that I am new to EPBCS, I would like some help to design rules that are similar to VLOOKUPS in Excel. Here is an example:

FTE % (Driver input by users) * Average Office Level Hours (this would be the data I would need to retrieve via VLOOKUP) to get Standard Hours of an employee

How should I go about this?

Thanks in advance,