Hi! I use Swedish Xl so forgive if my commands are not correct. I use
=lookforrow() in order to single out values in one list and make a new list.
The old list (list A) has dates and corresponding values. The problem is
that the dates repete themselves and some dates are missing (ie not all dates
in a year need to be in the list). I have a new list (list B) that consits
only of all dates in the year 2006. I want to find the correpsonding value in
list A that matches the date in list B. I use: =lookforrow(ListB;the whole
list A; second column that has corresponding value). Thhis works fine but
there is a problem. Say that list A has a value for 2006-01-10. The value is
900. Now if 2006-01-11 is not in List A I will get the value 900 for that
date in list B. I want to have n/a. Is there any way to solve this? Pls help!