Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
plotting column chart whch colors the bars diff for diff comm | Charts and Charting in Excel | |||
SUMIF formula required to search for 2 diff values in 2 diff colum | Excel Worksheet Functions | |||
how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
Retrieve cell value basis the inputs into a diff cell // sk. | Excel Worksheet Functions |