IF last cell is blank, then last non blank cell

[jwillis07]

Hi all, can anyone help me with this.

I've currently got in cell B1 copied across Row 1.

=IF(B2<>"",B2&C2,A2&C2)

I need it to say...

=IF(B2<>,"",B2&C2,LAST NON BLANK CELL IN ROW&C2


Thanks in advance.

Jason

[Pete_UK]

I tink this is what you are trying to do - put this formula in B1:

=LOOKUP("zzz",$B2:B2)&B3

then copy across.

Hope this helps.

Pete

[jwillis07]

I tink this is what you are trying to do - put this formula in B1:

=LOOKUP("zzz",$B2:B2)&B3

then copy across.

Hope this helps.

Pete

Yeah that works brilliantly. Thanks Pete!

[Pete_UK]

You're welcome - thanks for feeding back.

Pete