Jan 14 2022 10:58 PM
Jan 14 2022 11:13 PM
@Dboobalan Use TRUE as the last argument in the formula. That will return the closest match that is not greater than the lookup value.
=VLOOKUP(A3,Sheet3!A:A,1,TRUE)