RANK using Vlookup or MATCH

[brooksc29]

I am trying to say:

Get the text in cell B6, match that text in named range ALBA, then rank the data in N3:N14 for the line that has the text form B6.

how do I combine the two?

Thanks to all!

 

[Haseeb Avarakkan]

Perhaps you can just use a VLOOKUP, i.e.

=RANK(VLOOKUP(B6,ALBA,13,0),INDEX(ALBA,0,13))

That is cool Barry. I thought the lookup value cannot be always in first column. Also good for the dynamic data.

 

[brooksc29]

last question, I promise!

if I wanted to make that formula descending, instead of ascending, how would I do that?

 

[brooksc29]

I added a ,1 in between the last two )) and it seems to work