Left Lookup with Vlookup Excel Function

VLOOKUP formula that looks Left instead of Right

Vlookup B1 in Column A

=VLOOKUP(B1, CHOOSE({1,2}, B1:B5, A1:A5), 2,0) [Formula]

The formula returns the string “Jack”. (Refer Table 1)

Formula does a Vlookup on B1, choosing Column B as first column and Column A as second column, in the table_array.

Returns matching value from col_index_num 2 (ie. column A), in table_array.

=CHOOSE({1,2}, B1:B5, A1:A5) [Formula Break]

This part of the formula, chooses columns and rearranges their order in table_array: (B1:B5, A1:A5).

———————————————————————————————————————–

Vlookup C3 in Column A

=VLOOKUP(C3, CHOOSE({1,2}, C1:C5, A1:A5), 2,0) [Formula]

The formula returns the string “Romeo”. (Refer Table 2)

Formula does a Vlookup on C3, choosing Column C as first column and Column A as the second column.

Returns matching value from col_index_num 2 (ie. column A), in the table_array.

=CHOOSE({1,2}, C1:C5, A1:A5) [Formula Break]

This part of the formula, chooses columns and rearranges their order in table_array: (C1:C5, A1:A5).

———————————————————————————————————————–

Vlookup C3 in Column B

=VLOOKUP(C3, CHOOSE({2,3,4}, D1:D5, C1:C5,B1:B5, A1:A5), 2,0) [Formula]

The formula returns the value 44. (Refer Table 3)

The formula does a Vlookup on C3, choosing Column C as first column, Column B as second column and Column A as third column.

Returns matching value from col_index_num 2 (ie. column B), in the table_array.

=CHOOSE({2,3,4}, D1:D5,C1:C5, B1:B5, A1:A5) [Formula Break]

This part of the formula, chooses columns and rearranges their order in table_array: (C1:C5, B1:B5, A1:A5).

————————————————————————————————————————

Vlookup B2 in Column A

=VLOOKUP(B2, CHOOSE({3,1,4}, D1:D5, C1:C5, B1:B5, A1:A5), 3,0) [Formula]

The formula returns the string “Jill”. (Refer Table 4)

The formula does a Vlookup on B2, choosing Column B as first column, Column D as second column and Column A as third column.

Returns matching value from col_index_num 3 (ie. column A), in the table_array.

=CHOOSE({3,1,4}, D1:D5,C1:C5, B1:B5, A1:A5) [Formula Break]

This part of the formula, chooses columns and rearranges their order in table_array: (B1:B5, D1:D5, A1:A5).

VBA TUTORIAL LOGIN