Hi
try:
= Vlookup(A1, D1:E1000, 2,0)
--
Regards
Frank Kabel
Frankfurt, Germany
"Jeff" schrieb im Newsbeitrag
...
Hi,
For a product I have a date and a number associated with each date
Col C:C = Product
D:D = Date
E:E = Number
Then in Col A:A there is the current Date in A1 and the dates descend
to
yesterday, the day before, etc.
Problem is that I want to do a lookup in Col B
B1 = Vlookup(A1, D1:E1000, 2)
To get the number. But I am always updating the range D1:E1000, so
that if
the range is not sorted Vlookup skrews up.
In general how do you handle a Vlookup that is looking up a range
that
changes.
|