Remember Me?

#1
December 2nd 04, 02:31 PM
 Jeff Posts: n/a
Vlookup Question

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.

#2
December 2nd 04, 02:36 PM
 Peo Sjoblom Posts: n/a

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)

"Jeff" wrote in message
...
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.

#3
December 2nd 04, 02:40 PM
 Frank Kabel Posts: n/a

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 = 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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post KG Excel Discussion (Misc queries) 9 May 21st 05 07:12 PM KayR Charts and Charting in Excel 4 January 23rd 05 08:16 PM Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM Jeff Excel Discussion (Misc queries) 8 December 1st 04 02:41 PM Steve Jones Excel Discussion (Misc queries) 0 November 29th 04 05:01 PM

All times are GMT +1. The time now is 02:38 PM.