Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel formula question?
Ok. Sheet 1 is all of my data. Sheet 2 is certain data pulled from sheet one. I change the Sheet 1 data monthly, but I want the Sheet 2 formulas to be locked on to the Sheet 1 cells. I don't want the formulas to follow the data when I change it every month.
Example.
Sheet 1 cell n3 has January xyz data. One of the formulas in sheet 2, pulls whatever data is in n3. Next month, n3 will be a February data which. Only when I move January data to m3 and insert feb data into n3, my formula changes to m3 so it can follow the data rather than lock onto the cell. I hope I not way too confusing.
Bottom line, I want the formula to lock onto a cell and not change, instead of changing as the data moves to a different spot.
Thanks!!
That is what I'm saying. I need the formula to NOT change and follow the data. I need it to stay locked onto whatever cell I tell it to. There has to be a way!
3 Answers
- Bubba the HuttLv 41 decade agoFavorite Answer
You have a couple of options. If you don't mind having a new column of data for each month, then what you may want to do is change the "n3" to a month. Up in the top left where you see N3 you can highlight that and rename that cell, for instance "January08". Then you could go to sheet 2 and change the formulas to look for "January08" instead of "n3".
I'm assuming you have more than one cell with January data, so you would rename the cells something like "January08a, January08b" or "January081, January082, etc with the "1" or the "2" representing the row the cell is in.
If you do this the formulas on Sheet 2 will look up specific cells, not a range that changes all the time (as long as you changed their range to look for the new name of the cell -January08-, instead of it's column and row ID -n3-
There is another method that would involve the formulas on Sheet 2 to look at the date range for values entered on Sheet 1. =hlookup(), but you'd have to add some data and it could get complicated.
Or if you want I could do it for you. Send me an email if you'd like.
- 1 decade ago
If you are saying that your formula changes to take m3 cell data when n3 moves into m3 then I would say that is not possible. Formula will always use n3 data and if you push feb data into it the formula result will change accordingly...
- Anonymous1 decade ago
How are you pulling the Data from Sheet 1?
Are you familiar with Macro's?
