Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Min | Max | Score |
---|---|---|
0 | 10 | 0 |
11 | 50 | 25 |
51 | 100 | 50 |
101 | 250 | 75 |
251 | 1000 | 100 |
hey Hi,
why not to use left join in the back end script, tht will give the desired O/P of VlookUp in any scenario.
I'm trying to loosely link an expression (with set analysis) result with a data island. How do you do that with a left join even at the back end of a scrip to an expression result? In 99.9% of the cases, moreover, there will actually be no match to the fields in the data island. I'm looking for a match that is closest to the expression result without being greater than the result.