Match function in a two input table
 

I had set up a two input table, using =table function. It seem like the Match
function can not work with it.
My table is:
Year
£14,185.60 1 2 3 4 5
Machine A 9203.00 14185.60 10128.52 7231.76 5163.48 3686.72
Machine B 9611.00 13888.00 9999.36 7199.54 5183.67 3732.24
Machine C 9050.00 14284.80 10170.78 7241.59 5156.01 3671.08

The number 14.185.60 contains the formula =DB
The first column is the residual of all the machines. I need to find the max
of depreciation of each year then see which machine loses the most value in
each year. I already calculated the max for each year but i can not use match
to see which machine is..Is there any other way? Or why i can not do it??

Thx a lot

Match function in a two input table
 

What formula? What does "can not use match" mean? What input values, what
result did you expect and what did you get instead?

--
Kind regards,

Niek Otten

"Anh" wrote in message
...
I had set up a two input table, using =table function. It seem like the
Match
function can not work with it.
My table is:
Year
£14,185.60 1 2 3 4 5
Machine A 9203.00 14185.60 10128.52 7231.76 5163.48 3686.72
Machine B 9611.00 13888.00 9999.36 7199.54 5183.67 3732.24
Machine C 9050.00 14284.80 10170.78 7241.59 5156.01 3671.08

The number 14.185.60 contains the formula =DB
The first column is the residual of all the machines. I need to find the
max
of depreciation of each year then see which machine loses the most value
in
each year. I already calculated the max for each year but i can not use
match
to see which machine is..Is there any other way? Or why i can not do it??

Thx a lot

Match function in a two input table
 

Is it u ask the formula =DB? That is for calculate depreciation rate. "Can
not use match" means i can not use =Match function to find a value in this
table. The situation is i have a cell to calculate the max value of
depreciation in a specific year & i want to see which machine that the
depreciation value (i had entered) belongs to.

A B C
D E F
1 £14,185.60 1 2 3
4
2 Machine A 9203.00 14185.60 10128.52 7231.76 5163.48
3 Machine B 9611.00 13888.00 9999.36 7199.50 5183.67
4 Machine C 9050.00 14284.80 10170.78 7241.59 5156.01

The range C2:F4 is an array with the function {=TABLE} Then now my =Max
function is entered in cell C7 & i could find the maximum value of each year,
then i want to outcome to be display in cell C8 (as i said a bove i want to
lookup on the table to see which machine the value i entered belong to). Then
i enter in cell C8 the formula =INdex(A2:F4,Match(C7,C2:F4,0),1).
I can not see anything wrong with it..but then the outcome in cell C8 is #N/A.


"Niek Otten" wrote:

What formula? What does "can not use match" mean? What input values, what
result did you expect and what did you get instead?

--
Kind regards,

Niek Otten

"Anh" wrote in message
...
I had set up a two input table, using =table function. It seem like the
Match
function can not work with it.
My table is:
Year
£14,185.60 1 2 3 4 5
Machine A 9203.00 14185.60 10128.52 7231.76 5163.48 3686.72
Machine B 9611.00 13888.00 9999.36 7199.54 5183.67 3732.24
Machine C 9050.00 14284.80 10170.78 7241.59 5156.01 3671.08

The number 14.185.60 contains the formula =DB
The first column is the residual of all the machines. I need to find the
max
of depreciation of each year then see which machine loses the most value
in
each year. I already calculated the max for each year but i can not use
match
to see which machine is..Is there any other way? Or why i can not do it??

Thx a lot

Match function in a two input table
 

=INDEX(A2:A4,Match(C7,C2:C4,0))

--
Kind regards,

Niek Otten


"Anh" wrote in message
...
Is it u ask the formula =DB? That is for calculate depreciation rate. "Can
not use match" means i can not use =Match function to find a value in this
table. The situation is i have a cell to calculate the max value of
depreciation in a specific year & i want to see which machine that the
depreciation value (i had entered) belongs to.

A B C
D E F
1 £14,185.60 1 2 3
4
2 Machine A 9203.00 14185.60 10128.52 7231.76 5163.48
3 Machine B 9611.00 13888.00 9999.36 7199.50 5183.67
4 Machine C 9050.00 14284.80 10170.78 7241.59 5156.01

The range C2:F4 is an array with the function {=TABLE} Then now my =Max
function is entered in cell C7 & i could find the maximum value of each
year,
then i want to outcome to be display in cell C8 (as i said a bove i want
to
lookup on the table to see which machine the value i entered belong to).
Then
i enter in cell C8 the formula =INdex(A2:F4,Match(C7,C2:F4,0),1).
I can not see anything wrong with it..but then the outcome in cell C8 is
#N/A.


"Niek Otten" wrote:

What formula? What does "can not use match" mean? What input values, what
result did you expect and what did you get instead?

--
Kind regards,

Niek Otten

"Anh" wrote in message
...
I had set up a two input table, using =table function. It seem like the
Match
function can not work with it.
My table is:
Year
£14,185.60 1 2 3 4 5
Machine A 9203.00 14185.60 10128.52 7231.76 5163.48 3686.72
Machine B 9611.00 13888.00 9999.36 7199.54 5183.67 3732.24
Machine C 9050.00 14284.80 10170.78 7241.59 5156.01 3671.08

The number 14.185.60 contains the formula =DB
The first column is the residual of all the machines. I need to find
the
max
of depreciation of each year then see which machine loses the most
value
in
each year. I already calculated the max for each year but i can not use
match
to see which machine is..Is there any other way? Or why i can not do
it??

Thx a lot

Match function in a two input table
 

I'm confused by your array addresses.

Say machine names in A1 to A3.
Say values for the machines go out 5 years to Column F,
so data range is A1 to F3.

You have a formula in C7:
=MAX(B1:F3)

To find which machine that max value belongs to, try this:

=INDEX(A1:A3,MAX(IF((B1:F3=C7),ROW(1:3))))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Anh" wrote in message
...
Is it u ask the formula =DB? That is for calculate depreciation rate. "Can
not use match" means i can not use =Match function to find a value in this
table. The situation is i have a cell to calculate the max value of
depreciation in a specific year & i want to see which machine that the
depreciation value (i had entered) belongs to.

A B C
D E F
1 £14,185.60 1 2 3
4
2 Machine A 9203.00 14185.60 10128.52 7231.76 5163.48
3 Machine B 9611.00 13888.00 9999.36 7199.50 5183.67
4 Machine C 9050.00 14284.80 10170.78 7241.59 5156.01

The range C2:F4 is an array with the function {=TABLE} Then now my =Max
function is entered in cell C7 & i could find the maximum value of each
year,
then i want to outcome to be display in cell C8 (as i said a bove i want
to
lookup on the table to see which machine the value i entered belong to).
Then
i enter in cell C8 the formula =INdex(A2:F4,Match(C7,C2:F4,0),1).
I can not see anything wrong with it..but then the outcome in cell C8 is
#N/A.


"Niek Otten" wrote:

What formula? What does "can not use match" mean? What input values, wha
t
result did you expect and what did you get instead?

--
Kind regards,

Niek Otten

"Anh" wrote in message
...
I had set up a two input table, using =table function. It seem like the
Match
function can not work with it.
My table is:
Year
£14,185.60 1 2 3 4 5
Machine A 9203.00 14185.60 10128.52 7231.76 5163.48 3686.72
Machine B 9611.00 13888.00 9999.36 7199.54 5183.67 3732.24
Machine C 9050.00 14284.80 10170.78 7241.59 5156.01 3671.08

The number 14.185.60 contains the formula =DB
The first column is the residual of all the machines. I need to find
the
max
of depreciation of each year then see which machine loses the most
value
in
each year. I already calculated the max for each year but i can not
use
match
to see which machine is..Is there any other way? Or why i can not do
it??

Thx a lot