What's up with this?

Audiojoe · Mar 19th, 2002, 04:05 AM

I'm using VLOOKUP to do a query which is:

=VLOOKUP("Dan Howell",A1:F46,2)

which seems to be fine, except that whenever the position of Dan Howell changes I get #N/A? Does anyone know why and how I can stop it?

mrowe · Mar 19th, 2002, 04:16 AM

Does Dan move from the range you have in your lookup?

Dave Hawley · Mar 19th, 2002, 04:18 AM

Hi Joe

Use the Lookup_range argument and set it to False.

=VLOOKUP("Dan Howell",A1:F46,2,False)

Audiojoe · Mar 19th, 2002, 04:22 AM

Well, the position of Dan changes from day to day. It worked fine when I first put the formula in, but the next day it said #N/A when the position of Dan changed.

However, the formula that Dave Hawley just put on works fine. Dave, you are so the man, why are you not an MVP?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 04:05 AM	#1
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I'm using VLOOKUP to do a query which is: =VLOOKUP("Dan Howell",A1:F46,2) which seems to be fine, except that whenever the position of Dan Howell changes I get #N/A? Does anyone know why and how I can stop it?

Mar 19th, 2002, 04:16 AM	#2
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Does Dan move from the range you have in your lookup?

Mar 19th, 2002, 04:18 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Joe Use the Lookup_range argument and set it to False. =VLOOKUP("Dan Howell",A1:F46,2,False)

Mar 19th, 2002, 04:22 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Well, the position of Dan changes from day to day. It worked fine when I first put the formula in, but the next day it said #N/A when the position of Dan changed. However, the formula that Dave Hawley just put on works fine. Dave, you are so the man, why are you not an MVP?