Okay so I know this formula is not going to be so simple but here it goes:
The best way to explain this is with a picture because it would be way too confusing to explain the whole situation.
http://i.imgur.com/qztVH14.jpg?1
Now that you're looking at the picture, I would like a formula where the x1-3 and y1-3 from SHEET1 reflect its answers on SHEET2 where x1-3 and y1-3 are shown. I would like it so that if I fill in the formula where x1 is on SHEET2 and I drag it down to copy into where x2 and x3 are, it would be able to pull the answers from SHEET1. I purposely made spaces between rows on SHEET2, so please take that into account. Of course, with a little adjustment, y1 on SHEET2 would have a similar formula.
I have scoured the internet trying to figure out the formula to this. I'm not an Excel savvy person but I have tried TRANSPOSE, INDEX, INDIRECT, etc. in various ways, but I have had no luck. Please help!
Thanks!
Bookmarks