Nth cell of a column

[arbrahul]

I need to findout the nth cell of column B where the 'n' stands for the address of the last column of E.

So my requirement is to findout the Value in column B corresponding to the last row of Column E. I found the last row number of column E using the below formula..


=ROW(OFFSET(E1,COUNTA(E:E)-1,0))

Dont know how to use the result of this to find the value in column B of this row. Can someone help ?

[martindwilson]

assuming no blanks in col E
=INDEX(B1:B100,MATCH(TRUE,INDEX(E1:E100="",0),0))

[arbrahul]

Thank you for your reply ... There are blanks !

[Cutter]

Using what worked for you:

=INDEX(B:B,COUNTA(E:E)-1)

[npamcpp]

If column E has numbers, try

=INDEX(B1:B100,MATCH(99^99,E1:E100,1))

If column E has text, try

=INDEX(B1:B100,MATCH("zzzz",E1:E100,1))