Home » Forums » Open Source Learning Center » Question and Answer

VLOOKUP & IF together

Submitted by ulsk on 30 January, 2014 - 09:55

Hi
I want to get some figures from sheet1 to sheet2 using VLOOKUP. (I am ok with this). Then if this figure is less than 25, I want to print "25" in the cell (in sheet 2)and if it is over 25 then the same figure. How can I do this in sheet 2 on the values I get from sheet 1.
Tks/ulsk

‹ previous sheets How to Create Drop Down List with Multiple Subtitles? ›
»
Almir's picture

Nest VLOOKUP within IF

Submitted by Almir on 30 January, 2014 - 11:39.

=IF(Your_VLOOKUP_formula < 25,25,Your_VLOOKUP_formula)

»

Thanks a lot. It works.

Submitted by ulsk on 31 January, 2014 - 07:31.

Thanks a lot. It works.

»
Almir's picture

Glad being able to help you.

Submitted by Almir on 31 January, 2014 - 08:07.

Glad being able to help you.

»