Let's take one of the pieces of the problem first: that of getting the 0 1 2
3 4 entries from table 1 to show up as a list in your second table. The
easiest way to do that is to copy all of those entries and then use
Edit -- Paste Special with the Transpose option selected somewhere on the
same sheet with the second table. Then use that list as the source for your
data validation for the first column. You can always hide this 'helper'
column of data for neatness.

As for pulling data from table 1 into table 2:
Assumptions:
Table 1 begins at A1 on a sheet (A1 being the empty cell above 200 and to
the left of 0). I'll call that sheet 'Table1Sheet'.
The second table begins in H2 on the same sheet, so the 0 is in H2, the 200
is in I2.
That puts your first {info] entry at J2.

For my table 1 I went from 0 to 4 in row 1, and from 200 to 209, so that
table actually occupies the range $A$1:$F!11.

In cell J2, use this formula:
=INDEX($A$1:$F$11,MATCH($I2,$A$1:$A$11),MATCH($H2, $A$1:$F$1))

It doesn't make much sense (to me) to have multiple {item} entries next to
your
0 200 entries (the selections), since for any given pair of coordinates,
there is only one value in table 1. But maybe I'm missing something
somewhere?


"Squeeker" wrote:

I have one sheet layed out as follows:

0 | 1 | 2 | 3 | 4 | etc:
200
201
202
203
etc:

They are cordinates.

My second table is layed out as follows:

0 | 200 | {info} | {info} |

I want to match table one {say} 0 200 to table two 0 200 then pull
information from one of the {info} columns.

I know how to join using &" "&, but I can't figure out if to use an 'IF'
Statement or a LOOKUP or ROW or ADDRESS and how to make it work

I can get it to pull down and use absolute column, but when pull sideways,
it doesn't change correctly because when teh 0's turn to 1's it doesn't pull
them to the next column - if that makes sense.

I do notttt understand Macro's so please, if there is a way to do this in
code, that is what I am looking for.