ASKER CERTIFIED SOLUTION
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
good one Neeraj, I'm sure I have needed this many times and i've come with a number of ways to do it but none of the so clean and tidy.
Thanks Arana! Glad you found it useful. :)
Can you please explain what the 9^9 is actually doing there?
9^9 returns just a large number which is not supposed to be in lookup column and with match_type with True, Match finds the last number in the lookup column.
Get it now, thank you.
Thank you very much.
You're welcome Flora!