Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 577
Default Reference Formula Help

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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default Reference Formula Help

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!



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 577
Default Reference Formula Help

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!




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default Reference Formula Help

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!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to reference every second row Neville Bailey[_2_] Excel Discussion (Misc queries) 4 April 14th 08 10:14 PM
Reference formula formula help Excel Discussion (Misc queries) 3 February 19th 07 02:47 PM
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
Look Up Reference Formula JR573PUTT Excel Discussion (Misc queries) 7 March 9th 06 10:14 PM
Is it Possible in a formula to have a formula for cell reference? RogerBarker Excel Worksheet Functions 3 February 16th 05 09:00 PM


All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"