Referencing Data in Non-Adjacent Columns

[Seaplane Jack]

Hello All:

I've been searching online for hours and can't seem to find help with what, intuitively, seems like an easy question. I have a "Data" tab where data is entered daily and then averaged on a weekly basis. I also have a "Summary" tab where I want to bring in only the weekly summary data to use for building charts/dashboards, etc. I cannot find a formula that can be copied to reference the data in the non-adjacent cells. I have attached a simple sample of what I'm trying to accomplish. When working, Cell C3 on the "Summary" tab should reflect the value of Cell H5 on the "Data" tab - or 17,800.

Feel free to point out the extremely obvious if I'm really missing the boat, here - I can take it!

Help???...and thanks in advance!!!

Non-Adjacent Cell Help.xlsx

[jeffreybrown]

In C3 on the summary sheet, try...

=INDEX(Data!$5:$5,MATCH(C2,Data!$2:$2,0))

...and copy over

[Seaplane Jack]

Jeff,

Worked like a charm! Not as easy as I would have thought (meaning I would not have come up with this)! Now I'm going to spend some time trying to understand exactly what the formula is doing. I won't be happy with just pasting your work and calling it a day!

Thanks so much! You saved me a lot of tedious and repetitive work!!!

Have a great rest of the day!

Andrew

[jeffreybrown]

You are very welcome Andrew. Thanks for the feedback.

Here is a place to help further your understanding of this function and there are videos to watch...

http://www.contextures.com/xlFunctions03.html

Please mark your thread as solved if so...