Pulling data from the last column

[BrianBank]

Hi All,

An easy question for all of you.

Imagine I have 4 columns A2, B2, C2, D2. Say I have data in B2 and D2, I always want to have the result in A2 with the data from the furthest right cell. In this case it would be D2.

What's the formula I put in A2?

Thanks again!

 

[Joe4]

One way:

=IF(D2<>"",D2,IF(C2<>"",C2,IF(B2<>"",B2,"")))

 

[Mister H]

Hi

I am no formula expert but I did some searching and came up with this formula which if placed in A1 will give you the value of the furthest cell to the right up to Column RSV. I played around a bit and it seems to work. Lol

Maybe someone else can tell you if there is an issue with this formula or correct it if I posted it wrong. If it works for you then just copy the formula down Column A

Here it is:

=LOOKUP(2,1/(B1:RSV1<>""),B1:RSV1)

Good Luck,
Mark