I feel this should be easier to find but I'm really struggling. I want to populate a column with names from another tab (depending on the class chosen in A1). When I paste my formula into a cell in Google Sheets, I want the formula to update the row numbers to the current row. Here is the formula pasted into row 2.

=IF(A1=Students!A1,Students!A2, IF(A1=Students!B1,Students!B2,"none"))

So to have this in row 3 I would have to manually update A2 and B2 to A3 and B3, and then the same for every row after that. Is there a way to have A and B match the row they are on?

Thanks in advance!!

  • Keep in mind that we can't see your spreadsheet. We don't know your layout, data, data types or end goal (and a lot of other things). Consider sharing a link to your sheet. You likely need only one formula to accomplish your goal instead of a formula in every row. But as things stand, there's no way to know any of that or to suggest a solution.
    – Erik Tyler
    Dec 5 '21 at 14:45
  • Thanks Erik but I found the solution, I was copying and pasting the formula where as I should have been copying the cell and then adding $ to anything I wanted kept as absolute.
    – Lee222uk
    Dec 5 '21 at 17:55
  • You are still using multiple drag-down formulas where one formula could be used to get all results for a column. But that's up to you.
    – Erik Tyler
    Dec 5 '21 at 18:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.