Looking up a value

[howard]

I have values in columns B:K row 6 to 29.

I have a formula =LARGE(B$6:B$29,1) in B33 to K33 to look up the largest values in each of the columns. I have the branch names in Cloumn A row 6 to 29

I would like to set up a formula to lookup the value in B33 and to give me the applicable branch name that appears in A6:A29 that pertainsd to this value

I have tried to set up a Vlookup,=VLOOKUP(B37,A6:B18,1,FALSE) ,but it results in #N/A

Your assistance will be most appreciated

 

[VoG]

Try

=INDEX($A6:$A29,MATCH(B33,B6:B29,0))

 

[howard]

Hi Peter

Thanks for the help, much appreciated