I need a cell to return a value if another cell is with a certain range

[Priceman99]

Hello,

Could someone please help,

I would like column M in the attached picture to return a value if a cell within column D is within the value ranges shown on the bottom of the page. Can this be done?

 

[Joe4]

Welcome to the Board!

Check out the "What is approximate match in VLOOKUP and how to use it" section of this link here: VLOOKUP Exact Match & Approximate Match

The way you have set-up your lookup table is good, and you should be able to match on column B and get the result you desire.

 

[kvsrinivasamurthy]

In M118. Change the ranges as required.

=LET(a,IFERROR(VALUE(B242:E264),0),b,D118:D226,IF(b="","",VLOOKUP(b,a,3,1)))