Vlookup Question

[Guest]

Hi,

For a product I have a date and a number associated with each date

Col C:C = Product
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.

 

[Peo Sjoblom]

If you are looking up exact match you don't have to sort the table

= Vlookup(A1, D1:E1000, 2,0)




--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Frank Kabel]

Hi
try:
= Vlookup(A1, D1:E1000, 2,0)