How to find the Value from the table comparing Two unit

Iron Contributor

Comparing the Two Unit and lookup a value .

3 Replies

Hi @ajmal pottekattil yoousuf 

 

You can use vlookup to look for value.

What value you want to find in what column?

@Jihad Al-Jarady 

please refer the attachment.

Hi @ajmal pottekattil yoousuf 

So, you want cell O10 to get the value from the table according to the value in cell N10, this is the formula you should write in Cell O10

=VLOOKUP(N10,J5:L46,2,FALSE)

 

See the file attached