Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default VLOOKUP not calculating - workbook protection issue?

I am trying to use the VLOOKUP function below, but when I type the formula in, which seems to be correct, no result occurs (not even the normal "N/A) and the cell just lists the formula as I type it. Is there some protection setting that prevents VLOOKUP results that I am missing?

In Sheet1 Col2, I am trying to confirm that the invoice# in Col1 exists in Sheet2 Col6 which has 258 rows of data with 6 columns of data:

Sheet1 Col2:
=VLOOKUP(A1,'Sheet2'!$A$1:$F$258,6,FALSE)

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default VLOOKUP not calculating - workbook protection issue?

2 things to try.

Firstly are you typing into a cell formatted as text? if so cut the formula
out, change the format to general and paste the formula back.

Second. Press ctrl ` (The ` is below the esc key). This toggles between view
formula and view values.

Mike

"DuncanR" wrote:

I am trying to use the VLOOKUP function below, but when I type the formula in, which seems to be correct, no result occurs (not even the normal "N/A) and the cell just lists the formula as I type it. Is there some protection setting that prevents VLOOKUP results that I am missing?

In Sheet1 Col2, I am trying to confirm that the invoice# in Col1 exists in Sheet2 Col6 which has 258 rows of data with 6 columns of data:

Sheet1 Col2:
=VLOOKUP(A1,'Sheet2'!$A$1:$F$258,6,FALSE)

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default VLOOKUP not calculating - workbook protection issue?

Evrything look good
I assume A1 is on sheet 1. That you are looking a column F on sheet 2. the
only thing that can be wrong is that the data on one sheet is text and the
other sheet is a number. check to see if a ' is in front of the data.

You can also double check the lookup by using the Edit Menu Find and
pastting what is in A1 into the find. Us the Option in find Within Workbook.
then find all. See if Find actually locates the data on sheet 2.

"DuncanR" wrote:

I am trying to use the VLOOKUP function below, but when I type the formula in, which seems to be correct, no result occurs (not even the normal "N/A) and the cell just lists the formula as I type it. Is there some protection setting that prevents VLOOKUP results that I am missing?

In Sheet1 Col2, I am trying to confirm that the invoice# in Col1 exists in Sheet2 Col6 which has 258 rows of data with 6 columns of data:

Sheet1 Col2:
=VLOOKUP(A1,'Sheet2'!$A$1:$F$258,6,FALSE)

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default VLOOKUP not calculating - workbook protection issue?

Mike

No need to cut and paste after re-formatting.

Just F2 and ENTER will do same thing.


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 09:43:05 -0800, Mike wrote:

2 things to try.

Firstly are you typing into a cell formatted as text? if so cut the formula
out, change the format to general and paste the formula back.

Second. Press ctrl ` (The ` is below the esc key). This toggles between view
formula and view values.

Mike

"DuncanR" wrote:

I am trying to use the VLOOKUP function below, but when I type the formula in, which seems to be correct, no result occurs (not even the normal "N/A) and the cell just lists the formula as I type it. Is there some protection setting that prevents VLOOKUP results that I am missing?

In Sheet1 Col2, I am trying to confirm that the invoice# in Col1 exists in Sheet2 Col6 which has 258 rows of data with 6 columns of data:

Sheet1 Col2:
=VLOOKUP(A1,'Sheet2'!$A$1:$F$258,6,FALSE)

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP not calculating - workbook protection issue? DuncanR Excel Discussion (Misc queries) 1 February 21st 07 07:23 PM
Cell Protection Issue Sukh Excel Discussion (Misc queries) 2 October 16th 06 02:18 PM
Excel Protection Issue keithash Excel Worksheet Functions 0 February 15th 06 10:17 PM
Cell Protection Issue Ket Excel Worksheet Functions 1 May 11th 05 02:10 AM
protection issue Peter Mitterboeck Excel Worksheet Functions 1 March 16th 05 04:52 AM


All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"