I have the following spreadsheet

A B C
1 Data AA Data AB Data AC
2 Data BA Data BB Data BC
3 Data CA Data CB Data CC
4 Data DA Data DB Data DC

Now, given that information, I want to reference this data in another
spreadsheet as such:

If "Data AA" is selected, I want for "Data AC" to be returned in the next
column. If I change the first column to Data "BA", I want for "Data BC" to
be automatically returned.

I've tried the LOOKUP formula without positive results. I would program it
to read what's in Column A, compare it to the data range, and it would return
something complelely on another row. Now, granted, in this table, I have 200
entries.

Anybody with any ideas? They'd be greatly appreciated!

Try this:

G1 = Data AA

=VLOOKUP(G1,$A$1:$C$4,3,0)

--
Biff
Microsoft Excel MVP


"Scott" wrote in message
...
I have the following spreadsheet

A B C
1 Data AA Data AB Data AC
2 Data BA Data BB Data BC
3 Data CA Data CB Data CC
4 Data DA Data DB Data DC

Now, given that information, I want to reference this data in another
spreadsheet as such:

If "Data AA" is selected, I want for "Data AC" to be returned in the next
column. If I change the first column to Data "BA", I want for "Data BC"
to
be automatically returned.

I've tried the LOOKUP formula without positive results. I would program
it
to read what's in Column A, compare it to the data range, and it would
return
something complelely on another row. Now, granted, in this table, I have
200
entries.

Anybody with any ideas? They'd be greatly appreciated!

Thanks! How in the world did that work over the formula I was using, I have
no idea, but it did!

"T. Valko" wrote:

Try this:

G1 = Data AA

=VLOOKUP(G1,$A$1:$C$4,3,0)

--
Biff
Microsoft Excel MVP


"Scott" wrote in message
...
I have the following spreadsheet

A B C
1 Data AA Data AB Data AC
2 Data BA Data BB Data BC
3 Data CA Data CB Data CC
4 Data DA Data DB Data DC

Now, given that information, I want to reference this data in another
spreadsheet as such:

If "Data AA" is selected, I want for "Data AC" to be returned in the next
column. If I change the first column to Data "BA", I want for "Data BC"
to
be automatically returned.

I've tried the LOOKUP formula without positive results. I would program
it
to read what's in Column A, compare it to the data range, and it would
return
something complelely on another row. Now, granted, in this table, I have
200
entries.

Anybody with any ideas? They'd be greatly appreciated!

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Scott" wrote in message
...
Thanks! How in the world did that work over the formula I was using, I
have
no idea, but it did!

"T. Valko" wrote:

Try this:

G1 = Data AA

=VLOOKUP(G1,$A$1:$C$4,3,0)

--
Biff
Microsoft Excel MVP


"Scott" wrote in message
...
I have the following spreadsheet

A B C
1 Data AA Data AB Data AC
2 Data BA Data BB Data BC
3 Data CA Data CB Data CC
4 Data DA Data DB Data DC

Now, given that information, I want to reference this data in another
spreadsheet as such:

If "Data AA" is selected, I want for "Data AC" to be returned in the
next
column. If I change the first column to Data "BA", I want for "Data
BC"
to
be automatically returned.

I've tried the LOOKUP formula without positive results. I would
program
it
to read what's in Column A, compare it to the data range, and it would
return
something complelely on another row. Now, granted, in this table, I
have
200
entries.

Anybody with any ideas? They'd be greatly appreciated!