Hi Guys,
I have just begun using excel and famaliarising myself with vlookup.

I have created a sales spreadsheet containing daily sales figures for staff.
I have tried to use vlookup to collate week to date data based on the staff members name, when a member of staff is in all week the formula works fine, however when no value or name is present for 1 day the value is automatically being returned n/a.

The formula looks up each day seperatly, i think i need to do something with iferror but im really struggling to make it work.

=((vlookup (c44, c6:k20, 2, false))+(vlookup (c44, m6:u20, 2, false))+(vlookup ( w6:ae20,2,false))+(vlookup (c44, c25:k39, 2, false))++(vlookup (c44, m25:u39, 2, false)))

Any help would be much appreciated