Excel Help

Book1 is a sporadic list of dates with values.

Book2 is longer list of dates based on business days in the calendar. I want to pull the B column value in Book 1 to the B column in Book 2 with the matching date and if there is no matching date, a 0 should be used.

I have setup the Lookup formula but it is keeping the value at the previous value instead of 0 when there is no match.

I need the formula for this.

Compétences : Excel

en voir plus : i need excel help, excel help business, book keeping business, excel help formula, need excel help, excel formula, book1, excel match formula, book keeping need, need book keeping, matching excel, business list excel, excel formula days dates, excel book, lookup excel, excel matching, excel list business, list business excel, dptrade, excel business list, excel lookup date, date lookup, book keeping excel, business excel, excel calendar

Concernant l'employeur :
( 40 commentaires ) Dallas, United States

Nº du projet : #2386129

Décerné à:


Please check the PM.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(3 Commentaires)