Hiya! Sometimes I set up a formula to get values from another sheet. For example:
But then, one day when pasting data into that sheet, I find that the columns have moved from their previous position. I think it would be better if, as a matter of best practice, instead of referring to a cell like "C2" I could locate the cell using the value of the first row which act as headers (it's not a table though). For example, the formula would refer to row two of whatever column has "Name" in the first row of that column.Please Login or Register to view this content.
I googled around and think this might be a problem for INDEX and MATCH. Does that sound right?
Bookmarks