View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Kline Don Kline is offline
external usenet poster
 
Posts: 1
Default INDIRECT function returning REF#

I'm trying to find the start of a column on a worksheet. The column start is
based on two variables - row number and column number.

The value of RC2 = "value_Gauranteed Cash Value".

The value of R1C3 is 11. This is the in whiich the "value_Gauranteed Cash
Value" is to be found by the match

"XMLSource" is a worksheet in the same workbook.

The correct answer would be for the function to return 46 - the row number
for the first exact match to the value in RC2.

=MATCH(RC2,INDIRECT("XMLSource!R1C"&R1C3&":R966C"& R1C3),0)

The match is supposed to tell me where in column 11 does it find the exact
match for the value in RC2. What I get is a REF#.

What am I doing wrong?