stuartmacdonald
New Member
- Joined
- May 26, 2009
- Messages
- 48
I have a VLOOKUP that works with some workbooks but not others. I'm wondering if SUMPRODUCT would work better, but despite numerous configurations, I can't get it to work...
Not sure where to put --
Any ideas on how to convert this to SUMPRODUCT?
=IFERROR(VLOOKUP(B18,'https://cles-my.sharepoint.com/personal/stuartmacdonald_cles_org_uk/Documents/Order book/Timesheets/[Timesheet_NM.xlsx]Projects_NM'!$A:$S,19,FALSE),0)
Not sure where to put --
Any ideas on how to convert this to SUMPRODUCT?
=IFERROR(VLOOKUP(B18,'https://cles-my.sharepoint.com/personal/stuartmacdonald_cles_org_uk/Documents/Order book/Timesheets/[Timesheet_NM.xlsx]Projects_NM'!$A:$S,19,FALSE),0)