i found solution using VLOOKUP and using FALSE as fourth argument. that works. only limitation seems to be that all colons must be in one sheet