Forum Discussion
Non-Consecutive Cell Referencing
Thank you also for your help. I will stick to your proposal for the reasons you give. But I will play around with all suggestions just to get an idea of how and why these functions work. Have a Merry Xmas!
MattKW1 wrote: I've read where someone used a formula using the INDIRECT function but that's beyond my beginner level.
To which I respond, don't sell yourself short. The only way any of us learn without taking courses (and maybe even then)--expecially in Excel--is by playing around with those things we don't yet know. "Playing around" sometimes goes by the term "trial and error." INDIRECT definitely is one of those functions, one of many, where it often takes a bit of trial and error to get it right, but it's truly far better to go through that than to just have the answer handed to you.
May I recommend for future times when you are feeling like you're in over your head that you acquaint yourself with ExcelJet, where there are really helpful descriptions, along with examples, of functions like INDIRECT. I've learned a lot there myself, over recent years, by adding what's shown there with a little bit of playing around myself.
You're not going to break anything by trial and error (I do recommend that you save a backup copy of your workbook first, especially if it's at, you know, work.)
Thank you for the inspiration. I sincerely appreciate all of you who have contributed answers, and I'll try to learn from them. By and large, I don't need to do more than beginner Excel, so it's great to come to fora like this where people are so willing to help when I am out of my comfort zone.