Inexact Vlookup to Populate Category from Separate Data Source

[bdoogan]

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? 

[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.

[bdoogan · Accepted solution]

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