Vlookup with IF statement

[Spryte]

Can someone assist...I need excel to perform a vlookup and if the value is less than 100.00 then return 0.00 otherwise return the value in the cell.

 

[Fluff]

Hi & welcome to MrExcel
How about
=IF(vlookup formula<100,0,Vlookup formula)

 

[Spryte]

Hi Fluff,

Below is the vlookup formula I currently use...can you please type out the corrected formula?

=VLOOKUP(C304,'Balances'!E$4:T$900,15,FALSE)

Thank you!

 

[Twollaston]

Hi Fluff,

Below is the vlookup formula I currently use...can you please type out the corrected formula?

=VLOOKUP(C304,'Balances'!E$4:T$900,15,FALSE)

Thank you!

=IF(VLOOKUP(C304,'Balances'!E$4:T$900,15,FALSE)<100,0,VLOOKUP(C304,'Balances'!E$4:T$900,15,FALSE))

 

[Spryte]

This works perfectly!! Thank you!

 

[Twollaston]

This works perfectly!! Thank you!

have a good weekend!