Hoping I can get some help with a formula that will do the following.

If the number in cell M9 is equal to a number in cell range L9:L28 then return the cell value beside from cell range K9:K28.

Examples as follows

If M9 equals L12 return K12

If M9 equals L23 return K23

Thanks

N