Hello, I have a WB with multiple columns of data, but not all of the columns have the same number of rows filled so it is getting tricky to match up data. I am using the following formula to find the data in the last filled cell of column G (or +/- rows as needed). But I need to find the value in Column A on the same row as what is being returned from G. Column A has a lot more rows used on it so I cannot simply repeat the formula that I used for G.
I tried using the match or Hlookup functions referencing the returned value from G (for instance, in this case I have this formula in N17 so I was trying to reference N17, maybe I can't do that?) but I am having no luck getting the syntax correct. I sure would appreciate any thoughts on how I could do this. Thank you,
I tried using the match or Hlookup functions referencing the returned value from G (for instance, in this case I have this formula in N17 so I was trying to reference N17, maybe I can't do that?) but I am having no luck getting the syntax correct. I sure would appreciate any thoughts on how I could do this. Thank you,
Code:
=INDEX(G:G,COUNTA(G:G)+1,1)