Removing #N/A Issues

[Excel-Access]

Hi

Could someone kindly modify the formulae Cell S5 to remove #N/A?

This happens when there is no data in rows U to AF

I would like to show this as blank please.

Thanks

[Keebellah]

Add the ISNA function to your formulas,

[jeffreybrown]

You can wrap your formula with IFERROR...

=IFERROR(INDEX($U$2:$AF$2,MATCH(1,($U5:$AF5>0)*($U$2:$AF$2>0),0))+R5,"") >> Still CSE entered

[Excel-Access]

Many thanks Jeffrey Brown and Keebellah

[jeffreybrown]

You are very welcome. We are happy to help and thanks for the feedback.

[Keebellah]

Great to hear, happy coding