Hi all!
I'm in dire need of help. =(
I have 2 tables:
Table 1: is what I need to be filled out. The column I need to fill out is the Standard Level.
Table 2: is my reference table.
The criteria that needs to matched are the Standard Title, Market Grade, and BillRate.
The pinch is that the BillRate on the Table 1 does not exactly match the billrate on table 2, it's either higher or lower, but that's acceptable, it just needs to be within +/-15% range or whatever is closest if it's beyond +/-15% [I know. It's confusing. =(].
It's easy enough using IndexMatch if the billrates match but the threshold is killing me. =(
Help please!!
Bookmarks