Hi guys, wondering if you can help
Column 'A' has a list of dates 1st Jan through to 31st Dec, but over in column 'J' I have a list of various dates that relate to a % value (occupancy). So I may have 11th Jan, followed by a jump to 13th Feb. In column 'K' I have the % value.
What I want to achieve is that in column 'B' returns the value of 'K' only when matching the date. So for instance 1st Jan is not listed in 'J' so a zero/ null returned. But when the date is listed in 'J' the value will be displayed in B. I need it to display both null and valid value in column 'B'.
I hope this makes sense, and hopefully someone can help
Thanks
Bookmarks