vlookup columns not next to each other code example Example: vlookup columns not next to each other =VLOOKUP(A1,CHOOSE({1,2},Column1,Column2),2,FALSE)