I’m wondering if there is a formula in Deski which I can use to perform something like a vlookup in excel.
Hopefully I can explain what I’m trying to achieve.
I work in an audit function where we have a plan which provides coverage of the individual business areas in our organisation.
In my data source each plan item has a . Each will have one or more mappings to the business area(s) that the work undertaken will cover () .
From time to time, plan items need to be cancelled and part of the cancellation process requires us to understand how coverage would be impacted.
I can build a query which returns the associated list for the specific being cancelled. For this example, that query will be called QRY1.
I can also run a broader query to see the coverage provided by our overall plan. This will return all plan items (ie. all values) together with details of which associated values have been selected for each . Each unique will feature only once in this second query but the can feature multiple times (although not more than once per ). For this example, this query will be called QRY2.
Before we approve any cancellation for the in QRY1, we want to be able to identify if any of the values from QRY1 are being covered by other records in QRY2. In excel we could do a straight forward vlookup but I would prefer to be able to show any matches in in the data returned in QRY2.
I can use the ‘UserResponse’ formula to identify the selected from QRY1 and use that in QRY2 but I’m struggling to find a way to bring the from QRY1 into QRY2. I’ve tried various combinations of calculation context but nothing seems to work in identifying the matching items.
Hoping someone on the BOB can point me in the right direction.
dgroat (BOB member since 2010-09-10)