VBABEGINNER, Good afternoon.
There are a lot of ways to solve this kind of question using
Excel.
Using
VLOOKUP function:
Scenario:
Your data -->
E2:E17
Create a little table as Support: (
suggestion only)
[TABLE="class: grid, width: 220"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]M[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]= K2 & "-" & L2[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]= K3 & "-" & L3[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]= K4 & "-" & L4[/TD]
[/TR]
</tbody>[/TABLE]
Try to use:
F2 -->
Code:
[B]=VLOOKUP(E2, $K$2:$M$4, 3, TRUE)[/B]
Copy the formulas down.
https://www.sendspace.com/file/qzg16h
Is that what you want?
I hope it helps.