dear all,

1) i got the help from this forum of the intersect. may i know if i want
user to input the column and row in respective cell then the result will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if i have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result cell is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot

Hi
1. if you enter the column as letter 8e.g. 'B') try:
=INDIRECT(E10&E11)

2. Personal.xls is a workbook which is opened automatically then you start
Excel (but hidden). It is used to store common macros which could be
accessed from all workbooks. See:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

3. Also see the above link for getting started with macros

--
Regards
Frank Kabel
Frankfurt, Germany
"mango" schrieb im Newsbeitrag
...
dear all,

1) i got the help from this forum of the intersect. may i know if i want
user to input the column and row in respective cell then the result will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if i
have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result cell
is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mango" wrote in message
...
dear all,

1) i got the help from this forum of the intersect. may i know if i want
user to input the column and row in respective cell then the result will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if i
have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result cell
is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot

Mango,

1) Not sure on this one, but do you mean this in E12

=INDIRECT(E10) INDIRECT(E11)

2) Personal.xls is a special spreadsheet where you can store personal
information, such as macros. This spreadsheet is stored in the XLStart
directory, and as such will automatically load when Excel starts, but will
not be visible.

3) Addins are another special workbook, which are used to store macros,
functions, or complete applications. They differ from Personal.xls in that
they have to be loaded (against being in the XLStart directory) using the
Addins manager (ToolsAdd-ins...). Again, when loaded, the workbook is not
visible, but unlike Personal.xls it cannot be unhidden from
FormatSheetsUnhide.

Personal.xls tends to be for stuff just for you. Addins are for stuff you
want to distribute for many users. You will find many addins available from
many of the posters here (John Walkenbach's FaceId add-in, Rob Bovey's Excel
Utilities, Stephen Bullen's ... many and varied, Jan-Karel Pieterse's
NameManager .... all great applications delivered by addins.)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mango" wrote in message
...
dear all,

1) i got the help from this forum of the intersect. may i know if i want
user to input the column and row in respective cell then the result will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if i
have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result cell
is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot

dear all,
thanks for the reply
1) mary tom ginny
rental 100 230 200
food 40 38 70

at the cell i put = mary food then will return 40 (tools,option, calculation
accept labels)
now, instead asking user to key in the function above, i want to hv 3
different cell

input column : mary
input row : food
result : 40 (this cell will show once user input the above 2
cells)

i used indirect function but return ref#






"Bob Phillips" wrote:

Mango,

1) Not sure on this one, but do you mean this in E12

=INDIRECT(E10) INDIRECT(E11)

2) Personal.xls is a special spreadsheet where you can store personal
information, such as macros. This spreadsheet is stored in the XLStart
directory, and as such will automatically load when Excel starts, but will
not be visible.

3) Addins are another special workbook, which are used to store macros,
functions, or complete applications. They differ from Personal.xls in that
they have to be loaded (against being in the XLStart directory) using the
Addins manager (ToolsAdd-ins...). Again, when loaded, the workbook is not
visible, but unlike Personal.xls it cannot be unhidden from
FormatSheetsUnhide.

Personal.xls tends to be for stuff just for you. Addins are for stuff you
want to distribute for many users. You will find many addins available from
many of the posters here (John Walkenbach's FaceId add-in, Rob Bovey's Excel
Utilities, Stephen Bullen's ... many and varied, Jan-Karel Pieterse's
NameManager .... all great applications delivered by addins.)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mango" wrote in message
...
dear all,

1) i got the help from this forum of the intersect. may i know if i want
user to input the column and row in respective cell then the result will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if i
have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result cell
is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot

Hi mango

with mary in B6 and food in B7 the following formula works for me
=INDIRECT(B6) INDIRECT(B7)
(note the space before the second indirect)

alternatively you could use
=INDEX(A1:D3,MATCH(B7,A1:A3,0),MATCH(B6,A1:D1,0))

where your original table is in the range A1:D3

Hope this helps
Cheers
JulieD


"mango" wrote in message
...
dear all,
thanks for the reply
1) mary tom ginny
rental 100 230 200
food 40 38 70

at the cell i put = mary food then will return 40 (tools,option,
calculation
accept labels)
now, instead asking user to key in the function above, i want to hv 3
different cell

input column : mary
input row : food
result : 40 (this cell will show once user input the above 2
cells)

i used indirect function but return ref#






"Bob Phillips" wrote:

Mango,

1) Not sure on this one, but do you mean this in E12

=INDIRECT(E10) INDIRECT(E11)

2) Personal.xls is a special spreadsheet where you can store personal
information, such as macros. This spreadsheet is stored in the XLStart
directory, and as such will automatically load when Excel starts, but
will
not be visible.

3) Addins are another special workbook, which are used to store macros,
functions, or complete applications. They differ from Personal.xls in
that
they have to be loaded (against being in the XLStart directory) using the
Addins manager (ToolsAdd-ins...). Again, when loaded, the workbook is
not
visible, but unlike Personal.xls it cannot be unhidden from
FormatSheetsUnhide.

Personal.xls tends to be for stuff just for you. Addins are for stuff you
want to distribute for many users. You will find many addins available
from
many of the posters here (John Walkenbach's FaceId add-in, Rob Bovey's
Excel
Utilities, Stephen Bullen's ... many and varied, Jan-Karel Pieterse's
NameManager .... all great applications delivered by addins.)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mango" wrote in message
...
dear all,

1) i got the help from this forum of the intersect. may i know if i
want
user to input the column and row in respective cell then the result
will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if i
have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result
cell
is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot

INDIRECT as suggested by me, I think Frank's version is not what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mango" wrote in message
...
dear all,
thanks for the reply
1) mary tom ginny
rental 100 230 200
food 40 38 70

at the cell i put = mary food then will return 40 (tools,option,
calculation
accept labels)
now, instead asking user to key in the function above, i want to hv 3
different cell

input column : mary
input row : food
result : 40 (this cell will show once user input the above 2
cells)

i used indirect function but return ref#






"Bob Phillips" wrote:

Mango,

1) Not sure on this one, but do you mean this in E12

=INDIRECT(E10) INDIRECT(E11)

2) Personal.xls is a special spreadsheet where you can store personal
information, such as macros. This spreadsheet is stored in the XLStart
directory, and as such will automatically load when Excel starts, but
will
not be visible.

3) Addins are another special workbook, which are used to store macros,
functions, or complete applications. They differ from Personal.xls in
that
they have to be loaded (against being in the XLStart directory) using
the
Addins manager (ToolsAdd-ins...). Again, when loaded, the workbook is
not
visible, but unlike Personal.xls it cannot be unhidden from
FormatSheetsUnhide.

Personal.xls tends to be for stuff just for you. Addins are for stuff
you
want to distribute for many users. You will find many addins available
from
many of the posters here (John Walkenbach's FaceId add-in, Rob Bovey's
Excel
Utilities, Stephen Bullen's ... many and varied, Jan-Karel Pieterse's
NameManager .... all great applications delivered by addins.)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mango" wrote in message
...
dear all,

1) i got the help from this forum of the intersect. may i know if i
want
user to input the column and row in respective cell then the result
will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if
i
have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result
cell
is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot