Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I use a cell value as part of a cell refereren in a formula
One cell returns a numeric value (ex. 47)
using the match function, I want to use the above numerical value as the row for the array to search Example: 'Migration Rules'!$U$47:$AC$47 I tried using the concatenate function, but I could not get it to recognized the result as a cell reference |
#2
|
|||
|
|||
Try the Address function. See in-built help for syntax.
Rgds, ScottO "PMG" wrote in message ... | One cell returns a numeric value (ex. 47) | | using the match function, I want to use the above numerical value as the row | for the array to search | | Example: | 'Migration Rules'!$U$47:$AC$47 | | I tried using the concatenate function, but I could not get it to recognized | the result as a cell reference | |
#3
|
|||
|
|||
Try: =INDIRECT("'Migration Rules'!U"&K38&":AC"&K38)
where K38 will contain the numeric value: 47 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "PMG" wrote in message ... One cell returns a numeric value (ex. 47) using the match function, I want to use the above numerical value as the row for the array to search Example: 'Migration Rules'!$U$47:$AC$47 I tried using the concatenate function, but I could not get it to recognized the result as a cell reference |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
Counting values containing part of a cell | Excel Worksheet Functions | |||
=IF logical test to search only part of a cell | Excel Worksheet Functions | |||
worksheet tab name as part of a cell reference | Excel Worksheet Functions | |||
How do I test a cell for part of text | Excel Worksheet Functions |