Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Referencing
Had a wrong email address posted...please see above for
correct...thank you... Hi There, I wonder if anybody knows how to change a row reference dynamically within an argument string... I have the following example of a row array lookup from one sheet to another looking at column values that I want to make dynamic so it can apply to ANY row in a worksheet... Main sheet is called "Working", and the lookup sheet is called "Worksheet A" eg. MATCH(1, 'Worksheet A'!42:42, 0) I want to reference the row dynamically, ie. get rid of the 42:42 row reference and replace with a generic column lookup based on changing row which will be consecutive in sequence (they look at a pivot table). eg. MATCH(1, 'Worksheet A'!XX:XX, 0) Where I can change the "XX:XX" dynamically, with each iteration of the lookup (I will be incrementing and changing the reference, ie. 42:42, then 43:43, then 81:81, then 82:82, then 83:83, etc... I know this sounds tricky, but I wonder if anyone can help. Thanks in advance. Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Help | Excel Discussion (Misc queries) | |||
referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
referencing | New Users to Excel | |||
Help with referencing please | New Users to Excel | |||
Referencing | Excel Discussion (Misc queries) |