|  | concatenation in formula giving error | | |
| | | Utkarsh |  |
|  Posted: Mon Sep 01, 2008 12:37 pm Post subject: concatenation in formula giving error |  |
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? |
| |
| | | Bob Phillips | |
| | Posted: Mon Sep 01, 2008 12:37 pm Post subject: Re: concatenation in formula giving error | |
=MATCH(B8,INDEX(A:Z,,C7),0)
--
__________________________________
HTH
Bob
"Utkarsh" <utkarsh.majmudar@gmail.com> wrote in message
news:468df40d-256e-41ec-8e4a-5321a70bd311@m3g2000hsc.googlegroups.com...
| Quote: | 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? |
|
| |
|
|
