IFERROR with OFFSET

[ozbeachbum]

Hi,
I am endeavouring to bring the last amount from the last cell with an entry on a row, the following works as long as there is an entry on the row,
=OFFSET(BF75,0,MATCH(MAX(BF75:XFD75)+1,BF75:XFD75,1)-1)
However if there is no entry on the row I receive an #N/A message.
I thought the following would work,
=IFERROR(OFFSET(BF75,0,MATCH(MAX(BF75:XFD75)+1,BF75:XFD75,1)-1)),"")
but receive "You've entered to few arguments for this function".
Any assistance in correcting the formula would be greatly appreciated.
Cheers,
Dave.

 

[Peter_SSs]

It would be

=IFERROR(OFFSET(BF75,0,MATCH(MAX(BF75:XFD75)+1,BF75:XFD75,1)-1),"")

However, I would suggest using this non-volatile (& shorter) option to find the last number in the row

=IFNA(LOOKUP(9.9E+307,BF75:XFD75),"")

 

[ozbeachbum]

It would be

=IFERROR(OFFSET(BF75,0,MATCH(MAX(BF75:XFD75)+1,BF75:XFD75,1)-1),"")

However, I would suggest using this non-volatile (& shorter) option to find the last number in the row

=IFNA(LOOKUP(9.9E+307,BF75:XFD75),"")

Thanks once again Peter, so helpful as always and I have taken your suggestion.
Will be down your way shortly, taking one of our grandsons on the steam train that will be running out of Coffs Harbour in July.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

(I have sent you a conversation message about your Coffs Harbour trip)