How to lookup a Value from a horizontal table ?

[pacochin]

Hi,

Have you come across a situation whereby you data is arrange in a horizontal table., lets say you have 3 rows.


Row 1: Months

Row 2: Sales


How can I lookup the Month which has the highest sales ?

If it is a vertical table, we can use INDEX and MATCH, but if its horizontal table, what can we do ?

thanks

 

[Guest]

Hi,


Index works in both directions so just change the orientation of the Match.


The inline help for index should point you in the right direction.


HLookup works as a horizontal version of VLookup, but Index is more powerful as you can use it to go left & right, up & down as well.


Hope that helps,


M

 

[Ulrik Willemoes]

If you have Months in B1:G1, and Sales in B2:G2


try

=INDEX($B$1:$G$1,,MATCH(MAX($B$2:$G$2),$B$2:$G$2,0))

 

[pacochin]

Great ! It works ! Thanks so much !