how to convert a string to a reference?
- From: Miernik <miernik iname com>
- To: gnumeric-list gnome org
- Subject: how to convert a string to a reference?
- Date: Wed, 25 Jul 2001 00:02:29 +0200 (CEST)
I have the following problem:
I have a mutlisheet spreadsheet.
I want to have a function like:
=match(A3;indirect(concatenate(P2;"!A2:A6000"))
In A3 I have a date, I P2 I have a sheet name.
I want to find the row number in which the A3 date appears in sheet P2.
The function above doesn't work.
What is the proper way to do it?
--
Miernik _____________________________________
/ /
tel.: +48608233394 / / mailto:miernik ii pl
__________________/___/ ICQ UIN: 4004001
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]