Excel Help
$30 USD
Completed
Posted almost 12 years ago
$30 USD
Paid on delivery
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.
Project ID: 2386129
About the project
1 proposal
Remote project
Active 12 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2.0
2.0
About the client
Dallas, United States
40
Payment method verified
Member since Mar 21, 2012
Client Verification
Other jobs from this client
$30-250 USD
$30-250 USD
$30-250 USD
$30-250 USD
$10-30 USD
Similar jobs
₹750-1250 INR / hour
$15-25 USD / hour
₹12500-37500 INR
$10-30 USD
$15-25 USD / hour
₹750-1250 INR / hour
$15-25 USD / hour
$10-30 USD
₹12500-37500 INR
£20-250 GBP
£20-250 GBP
$30-250 USD
₹600-1500 INR
₹1000-1600 INR
$2-8 USD / hour
₹2000-8000 INR
€12-18 EUR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.