Hi everyone,
I'm trying to find a historical average for a certain type of data and match it to a specified metro area. For example, if I'm looking at unemployment data in Abilene, TX, I'd like to be able to choose Abilene, TX, and have a function return the entire row of data on Abilene.
Any thoughts?
I appreciate the help!
Alex
Hi
a standard formula, in A2:A100 list of areas, numbers in B2:Z100
=AVERAGE(INDEX(B2:Z100,Match("Georgetown",A2:A100,0),0))
With a sample file it's easier to help you
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thanks so much! As soon as I posted the thread, I figured out how to do it--I just needed to add a 0 in the column number slot within the index function.
Hi,
you're welcome.
Thanks for providing feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks