I am trying to write an if condition comparing the value in cell R to the value found in my Vlookup. If R is greater than or equal to the value I want it to return a zero. If it is less than or equal I want it to return a 1. It appears to only be returning a 1. Any ideas on what I am doing wrong. =IF(R2>=VLOOKUP(Y2,PortPairTransitTime!A:D,4,FALSE)*0,1)

=IF(R2>=VLOOKUP(Y2,PortPairTransitTime!A:D,4,FALSE)*0,1)Could be the * after your vlookup

Try:

=IF(R2>=VLOOKUP(Y2,PortPairTransitTime!A:D,4,FALSE),0,1)

MIKE

Ask Your Question

Weekly Poll