The table array argument is the block of contiguous data from which specific information is retrieved.
Usually, VLOOKUP only looks to the right of the lookup value argument to find data in the table array. To get it to look left, VLOOKUP must be tricked by rearranging the columns in the table array using the CHOOSE function.
Ещё видео!