hi, so i have 2 sheets: TR and KO, in sheet TR i need to check if U2 is smaller than 5, if it is then copy the value from T2, however, if its bigger than 5,than i need to search for value from T2 cell in sheet TR but on sheet KO column B. But i dont need to extract the same value as it was in T2 from sheet KO, but from the next cell of the same column in sheet KO. really sorry for the confusion, my english is limited
i came up with something like this, but i dont know how to make vlookup extract the next cell, rather than the same cell
=IF(U2<5;T2;VLOOKUP(T2;'KO'!B:B;BB3))

hope you understand what i said, i really need help here