Need Help With Vlookup or Match? I think?

[aedctalk]

Hello! This is what i'm trying to do.

I have a "current score" on Friday!E83

on PC11AM!AE149 to PC11AM!AE197 i have the top 25 values of a chart

On PC11AMAJ149 to PC11AM!AJ197 i have a message for reach. Rank # 1 Rank # 2 etc.


What i want to do is..

If current score Friday!E83 is equal to one of the "top" values in PC11AM149-197 then where they are equal i want to display the message in AJ column that correlates to the AE #'s

So say Friday is 3.83 then it looks at PC11AM for the 3.83 in the top 25 scores and then displays the correlating rank message

I have rank message set up. Have current score thing. Have top 25. I just need to figure otu how to match up the numbers and display the right message


Any help would be much appreciated!!!

 

[greenman]

try this...

=VLOOKUP(Friday!E83,PC11AM!$AE$149:$AJ$197,6,FALSE)