LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Referrencing to a diff cell

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.
 
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
Assign Color to a Cell based on another Cell on a diff Sheet VROSARIO7 Excel Worksheet Functions 2 July 6th 09 08:53 PM
plotting column chart whch colors the bars diff for diff comm Cathy Charts and Charting in Excel 5 March 19th 09 06:30 PM
SUMIF formula required to search for 2 diff values in 2 diff colum Lidy693 Excel Worksheet Functions 7 February 21st 09 09:45 PM
how you make links between diff. cells on diff. work sheets NYC-MIKE Excel Worksheet Functions 3 February 11th 08 05:05 PM
Retrieve cell value basis the inputs into a diff cell // sk. sansk_23 Excel Worksheet Functions 5 December 16th 07 08:06 AM


All times are GMT +1. The time now is 04:13 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"