Can anyone solve this mystery?

[stevek99022]

Greetings Everyone. For whatever reason, I have had no luck with anyone coming forward and being able to solve what appears to be the mystery problem. Please allow me to explain this dilemma; I currently have a sheet with 2 drop down menus in it with all 32 NFL teams. One is labeled Visiting team, while the other is the Home Team. Here is what I need to happen that is apparently confusing everyone. When I select a given team in the drop down lists, say, Arizona, I need excel to pull certain rushing, passing, INT'S, Fumbles, stats into this sheet so as to make a prediction of possible points scored and the overall winner. Not that this matters, but I've been told by several people that the solution lies in the vlookup command. Yet no one knows how to make it work properly apparently. Anything anyone can do to make this work properly will label you as a hero. Well, my hero anyway.
Regardless, thanks in advance for your help with this...

Steve

 

[Peter_SSs]

Welcome to the MrExcel board!

VLOOKUP or an INDEX/MATCH formula should probably do what you want.

However, without seeing what your data looks like and how it is laid out it would be hard to give you any specific formulas or advice.

Perhaps you could show us a small set of dummy data and the expected results?
My signature block below has a link for suggestions as to how you can do that in a way that will likely attract helpers.

BTW, we'd also prefer if you just used the standard forum font for your post unless there is something specific to highlight with bold.

 

[stevek99022]

Welcome to the MrExcel board!

VLOOKUP or an INDEX/MATCH formula should probably do what you want.

However, without seeing what your data looks like and how it is laid out it would be hard to give you any specific formulas or advice.

Perhaps you could show us a small set of dummy data and the expected results?
My signature block below has a link for suggestions as to how you can do that in a way that will likely attract helpers.

BTW, we'd also prefer if you just used the standard forum font for your post unless there is something specific to highlight with bold.

Perhaps a screen snap shot would possibly help?

 

[MARK858]

Perhaps a screen snap shot would possibly help?

See Peter's statement below. The tools he has suggested post screenshots that can be copied and pasted into Excel (if you post JPegs, Pngs etc. they can't and so greatly reduce the chance of people helping).

My signature block below has a link for suggestions as to how you can do that in a way that will likely attract helpers.

The orange "Look here" is a link.