concatenation in formula giving error

  • Thread starter Thread starter Utkarsh
  • Start date Start date
U

Utkarsh

Hi

I'm trying something like this:
=MATCH(B8,""""&INDIRECT("C7")&":"&INDIRECT("C7")&"""",0)

where C7 referes to the output of another match function that deliver
a column number (3, 4, etc.)

The formula returns #Value!

What am doing wrong?
 
Back
Top