Value calculation with criteria

[senthilkumar_rm]

Hi solvers


I have scenario where i want to get values by looking up the value in other cells

find below is criteria, i need a formula which looks the value in cell C3 and displays the corresponding value

A column B Column

Criteria Value C1 = 99.4

100 25

<100>99 15 D1 should display 15

<99>98 10

<98 0

 

[kaushik03]

Hello Senthil,


Your explanation is not very clear to me.


You said C3 is the value to be looked up. If that is correct then what C1 is here all about?


Can you please post the data layout in a bit proper way (probably by using backtick ( ` ) characters at the bigining and end of your data which you would copy and paste here., and also explain the criteria bit more clearly.


Kaushik