ChrisMac1
New Member
- Joined
- Jul 15, 2024
- Messages
- 34
- Office Version
- 365
- Platform
- Windows
Hi there, I'm hoping this is an easy fix.
I have a formula that returns 0's when there are blank cells in the results, what do I need to add and where so zero's are not added?
=IFERROR(IF(VLOOKUP(D2,'ARCHIVE SENT'!$D$2:$AK$10000,32,)>0,VLOOKUP(D2,'ARCHIVE SENT'!$D$2:$AK$10000,32,),AI2),AI2)
Many thanks,
Chris
I have a formula that returns 0's when there are blank cells in the results, what do I need to add and where so zero's are not added?
=IFERROR(IF(VLOOKUP(D2,'ARCHIVE SENT'!$D$2:$AK$10000,32,)>0,VLOOKUP(D2,'ARCHIVE SENT'!$D$2:$AK$10000,32,),AI2),AI2)
Many thanks,
Chris