Hey! Just registered to the site, but have been a long time lurker.
I was wondering if it is possible to use a lookup function (vlookup for instance) and force it to calculate the last populated cell in a row as the column index.
For instance:
<tbody>
</tbody>
Say I have this data set, is it possible create a formula that allows the lookup to find the last populated cell in the row and use that as the col_index_num?
I have been playing around max and column and managed to reference the column number of the last cell but cant seem to figure out how to use this in a lookup function.
Here is what I have so far:
=MAX(([the row selection]<>"")*(COLUMN([the row selection])))
It seems to work, but it relies on me manually selecting the row I want so wont work for a lookup function.
Thanks in advance!
I was wondering if it is possible to use a lookup function (vlookup for instance) and force it to calculate the last populated cell in a row as the column index.
For instance:
Unique Id | |||||
1032 | Text | Text | Text | 2695 | 0.0425 |
1150 | Text | 4575 | 0.0722 | ||
1151 | Text | Text | 266 | 0.0042 | |
1170 | Text | Text | Text | 14 | 0.0002 |
1174 | Text | Text | Text | 0.0089 |
<tbody>
</tbody>
Say I have this data set, is it possible create a formula that allows the lookup to find the last populated cell in the row and use that as the col_index_num?
I have been playing around max and column and managed to reference the column number of the last cell but cant seem to figure out how to use this in a lookup function.
Here is what I have so far:
=MAX(([the row selection]<>"")*(COLUMN([the row selection])))
It seems to work, but it relies on me manually selecting the row I want so wont work for a lookup function.
Thanks in advance!