Range of numbers - select the matching values

[tomsh]

Hello All,

I have a question and need your help to get the right formula. Here is the question, I have a set to values in Column A, Column B & Column C.

The value in Column A (which is the important and they may change daily) but column B & C don't change. Value is the column A has corresponding Value in B & C if Column A falls in the column b value the output should be the value in column C.


Sample excel sheet attached. Appreciate the time and suggestions help you do. Thanks.

 

[tomsh]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A -Values[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Output[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]62[/TD]
[TD]80[/TD]
[TD]238[/TD]
[TD]238[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]62[/TD]
[TD]81[/TD]
[TD]237[/TD]
[TD]237[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD]82[/TD]
[TD]237[/TD]
[TD]237[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD]83[/TD]
[TD]236[/TD]
[TD]236[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD]84[/TD]
[TD]236[/TD]
[TD]236[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD]85[/TD]
[TD]235[/TD]
[TD]235[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD]86[/TD]
[TD]235[/TD]
[TD]235[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD]87[/TD]
[TD]234[/TD]
[TD]234[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]71[/TD]
[TD]88[/TD]
[TD]233[/TD]
[TD]233[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]74[/TD]
[TD]89[/TD]
[TD]232[/TD]
[TD]232[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]76[/TD]
[TD]90[/TD]
[TD]232[/TD]
[TD]232[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]77[/TD]
[TD]91[/TD]
[TD]231[/TD]
[TD]231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]78[/TD]
[TD]92[/TD]
[TD]231[/TD]
[TD]231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]79[/TD]
[TD]93[/TD]
[TD]231[/TD]
[TD]231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]79[/TD]
[TD]94[/TD]
[TD]231[/TD]
[TD]231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]79[/TD]
[TD]95[/TD]
[TD]231[/TD]
[TD]231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]78[/TD]
[TD]96[/TD]
[TD]231[/TD]
[TD]231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]77[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Since column B & C are blank the output should pick the matching row value for 77 = 231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]This cell should be blank as there is no matching value for 75 in column b & C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]72[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]This cell should be blank as there is no matching value for 72 in column b & C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]69[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]This cell should be blank as there is no matching value for 69 in column b & C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]234[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]65[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]This cell should be blank as there is no matching value for 75 in column b & C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]235[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]