f2 & enter

Feb 28th, 2002, 01:04 PM

I have two sheets of zip codes that i am trying to vlookup off of and even though the two sheets are in the same format, the vlookup doesn't recognize the cells until I "f2" and then hit "enter". only after i hit "f2" and then "enter" am i able to get the desired result. HELP! I have over 16K zip codes that I need to query off of in the vlookup.

Chris Davison · Feb 28th, 2002, 01:42 PM

Quote:

On 2002-02-28 12:04, Anonymous wrote:
I have two sheets of zip codes that i am trying to vlookup off of and even though the two sheets are in the same format, the vlookup doesn't recognize the cells until I "f2" and then hit "enter". only after i hit "f2" and then "enter" am i able to get the desired result. HELP! I have over 16K zip codes that I need to query off of in the vlookup.

have you got manual calc switched on ?

try :

tools
options
calculation
calculation = automatic

Feb 28th, 2002, 02:10 PM

Yep, Calc is on automatic.

Chris Davison · Feb 28th, 2002, 02:19 PM

with 15,000 lookup functions, are you sure you're waiting for it to finish calculating ?

bottom right - if it says "calculating" you need to wait till it's finished...

JUst guessing here...

Feb 28th, 2002, 02:21 PM

It is definitely calculating. the problem is that excel recognizes some cells as numbers and others as characters even though the formatting is the same.

Chris Davison · Feb 28th, 2002, 02:23 PM

yeah, sorry, I just saw your parallel thread which looks like solving the problem.

Over and out.

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

Feb 28th, 2002, 01:04 PM	#1
Guest Posts: n/a	I have two sheets of zip codes that i am trying to vlookup off of and even though the two sheets are in the same format, the vlookup doesn't recognize the cells until I "f2" and then hit "enter". only after i hit "f2" and then "enter" am i able to get the desired result. HELP! I have over 16K zip codes that I need to query off of in the vlookup.

Feb 28th, 2002, 02:10 PM	#3
Guest Posts: n/a	Yep, Calc is on automatic.

Feb 28th, 2002, 02:19 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	with 15,000 lookup functions, are you sure you're waiting for it to finish calculating ? bottom right - if it says "calculating" you need to wait till it's finished... JUst guessing here...

Feb 28th, 2002, 02:21 PM	#5
Guest Posts: n/a	It is definitely calculating. the problem is that excel recognizes some cells as numbers and others as characters even though the formatting is the same.

Feb 28th, 2002, 02:23 PM	#6
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	yeah, sorry, I just saw your parallel thread which looks like solving the problem. Over and out.