Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP not calculating - workbook protection issue? | Excel Discussion (Misc queries) | |||
Cell Protection Issue | Excel Discussion (Misc queries) | |||
Excel Protection Issue | Excel Worksheet Functions | |||
Cell Protection Issue | Excel Worksheet Functions | |||
protection issue | Excel Worksheet Functions |