Hlookup for max value

[Pow3R]

Hello all, I have a range of data as table below and looking for the max cost for each item.
Wondering how can I use HLOOKUP to get the max cost.
Thanks for advance!

	Item A	Item B	Item C	Item A	Item D	Item B
Cost 1	2	4	5	10	9	20
Cost 2	11	8	22	4	8	5

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

Result

	Item A	Item B
Cost 1	10	20
Cost 2	11	8

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Item A >> 40, not 38; but Item C >> 15, not 29. How do we get into this? Are we looking for the last value or the max value?

 

[Aladin Akyurek]

	Item A	Item B	Item C	Item A	Item C	Item D
Cost 1
Cost 2
Cost 3
Cost 4	40	10	29	38	15	32
Looking for the maximum value of "cost 4" for each item
Result
	Item A	Item B	Item C	Item D
Cost 4

<tbody>
</tbody>

If the last value is meant...

In B10 control+shift+enter, not just enter, and copy across:

=LOOKUP(9.99999999999999E+307,IF($B$1:$G$1=B$9,INDEX($B$2:$G$5,MATCH($A10,$A$2:$A$5,0),0)))

If the max value is meant...

In B10 control+shift+enter, not just enter, and copy across:

=MAX(IF($B$1:$G$1=B$9,INDEX($B$2:$G$5,MATCH($A10,$A$2:$A$5,0),0)))

 

[Pow3R]

Well noted. Thanks Aladin

 

[Aladin Akyurek]

Well noted. Thanks Aladin

You are welcome.