Approximate Match Values

[kcorbin1]

Hi all,

I'm trying to roughly match values in my data. My company has an internal bill rate for internal reporting and then we invoice clients via an external bill rate depending on our market location. I have a key that matches the internal rate with the external rate but our timekeeper system has a larger variety of rates due to people working all over the country at different internal rates. I'm trying to approximately match the actual internal rate in a large set of WIP data with an internal rate in my key. At the end of the day, I want to be able to match any internal rate that is not zero with the closest external rate.

Thank you!

[Qiu · Accepted solution]

@kcorbin1 
I would assume that by "Approximate Match Values" you mean that the value in "Rate" column of "WIP sheet" should fall in the range between row and its last row of "FY24 INTERNAL Bill Rates" in the "Rate Key" Sheet.

Can you see something like this would help?

[kcorbin1]

Yes, thank you! This helped me get to what I needed.

[Qiu]

@kcorbin1 
Glad to help.