vlookup columns not next to each other

The solution for “vlookup columns not next to each other” can be found here. The following code will assist you in solving the problem.

=VLOOKUP(A1,CHOOSE({1,2},Column1,Column2),2,FALSE)

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts