Vlookup issue

Currently, I have multiple sheets where each sheet pulls in certain numbers from the web with a team assigned to it. Each sheets pulls values for NBA teams and ranks them highest to last. Certain sites have different orders so they are not always in the same row. My goal is to have a formula that goes to each sheet, finds team A and then pulls the rating from each sheet and averages them into 1 number.

I thought Vlookup was the solution for this but can't seem to get it to work. I have created this formula "=VLOOKUP("Chicago Bulls",NFrating,4,TRUE)" but all I get is #N/A . Is there a different way I should be doing this?

Thanks!

That was perfect Flame! Anyway to make it be able to pull those same values from multiple sheets?

Nevermind, I got it with this

Please Login or Register  to view this content.

I'm sure we can, but I'd like to see an example of what you have in mind. Can you upload another small representative sample file?