You may need to clarify that with an example of your data layout but if by
table you mean from a different Column then consider this

=VLOOKUP(A1,J1:N18,2,FALSE)

The table array in the above is 5 columns wide and the column to return is
set by the 2 in the formula which can be any of the 5 columns.

Mike

"Joe" wrote:

If I want to get the result from the first table instead of the second one.
Wot can I do?