| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fabricating Cell Address
Hello everyone. I need your help. I am programmatically determine the coordinates of needed cell. For example, I am interested in "=R18C3" But R18 was found using "=MATCH(""ITEM_ID"",C[-1],0) + 3" THIS EQUALS to 18. So, I know that my desired cell located in row 18. Is there a way in Excel 97, to concatenate or join this two together. I tried “=R[(MATCH(""ITEM_ID"",C[-1],0) + 3)C[1]”. But it does not work. I also tried =R&[ MATCH(""ITEM_ID"",C[-1],0) + 3}&C[1]… Is there a way to fabricate the cell address? Thank you in advance, Sonya -- Sonya795 ------------------------------------------------------------------------ Sonya795's Profile: http://www.excelforum.com/member.php...o&userid=26110 View this thread: http://www.excelforum.com/showthread...hreadid=396805 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| Using result from ADDRESS function as a cell reference itself | Excel Worksheet Functions | |||
Threaded Mode
