Inexact Vlookup to Populate Category from Separate Data Source

I'm trying to add an additional column to my data source which will map the days outstanding based on Reference ID to the corresponding category in a separate file. The final product should show Ref ID, Days, and Category.

I started going down the attached path but couldn't think of a next step to isolate on the last true value based on Ref ID.

Any thoughts?

vlookup test.yxmd

Developer

Accepted answers

bdoogan

Please disregard. I was able to work out an acceptable solution. See attached in case anyone else has the same issue.

vlookup test.yxzp

All comments

chinu267

the YXMD does not have the excel inputs. Either use TEXT INPUTS or else upload as a package file YXZP

bdoogan

Apologies as this is the first time posting something like this. See attached.

vlookup test.yxzp

bdoogan

Please disregard. I was able to work out an acceptable solution. See attached in case anyone else has the same issue.

vlookup test.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703