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