Find a value in the n-th column

  • Thread starter Thread starter pataki429
  • Start date Start date
P

pataki429

Hi,

I need a formula to find a value in a column. The column is not alway
the same, it might be the 3rd, 4th or any other column, so I need
reference something like: column(n). Any other idea is OK.

Thank
 
You could try using the offset function

=OFFSET(A3,0,A1) where A3 is you starting point, the 0 indicates the number of rows to move down (or up), and cell A1 contains a number corresponding to of column you wish to reference i.e if A1 has the value 2 this formula will return the value in cell C3

Regard
Rowan
 
You could try the OFFSET function or, if there is a criterion by which you
can determine which column to look in, a LOOKUP function or combined INDEX &
MATCH function might be the go.

Cheers
 
Back
Top