Value in column adjacent to the value found by LOOKUP

[JeffFinnan]

LOOKUP(2,1/(ISNUMBER(D:D)),D:D) will get me the last number in a column of data for which the values are #N/A after that last number. I would like to get the value in the column adjacent to this last number found by this LOOKUP formula.

 

[Joe4]

Adjacent how? To the left? To the right?

I think perhaps it would be helpful if you showed us a small data sample along with your expected results.

 

[RoryA]

The last argument is the range you want the data from so just change that:

=LOOKUP(2,1/(ISNUMBER(D:D)),E:E)

 

[Fluff]

Not sure which column you want, as there are two adjacent columns, but maybe

=LOOKUP(2,1/(ISNUMBER(D:D)),E:E)

 

[JeffFinnan]

=LOOKUP(2,1/(ISNUMBER(D:D)),E:E)

=LOOKUP(2,1/(ISNUMBER(D:D)),E:E)

Thanks both of you. Sorry about the lack of specificity for which adjacent side. Turns out it was C but easy enough to figure out.

 

[Fluff]

Glad we could help & thanks for the feedback.