Vlookup doesn't work in new workbook

MS EXCEL

    Next

  • 1. lookup related with defined name
    Hi, I have a filter that contains 12 ranges of 2 columns (on one sheet). Each one of those ranges I've given the specific name. The filter (each range) includes number of days (ascending) and the score (evaluation) for that number of days (actually it's a duration). OK... At the other sheet there is a table with the data about the customer's complaints and among that data there are records identical to those names I've defined for mentioned ranges at the sheet before. In the table data there is a duration, and for that value I wan't to show the score depending it's match in the filter. Or simple: Can I lookup the value within a range (name defined), if that "name" is shown in a cell next to the value? Actually, the data in that cell is not a name, it's a value with the same name as the name I've defined for the specific range. Is this explanation reasonable? Thank you all in advance! Kruno, Croatia
  • 2. Sum returning 0
    Hello, When using: =SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31,BT31) If hte cells are blank I get a 0 (zero). How can I write this formula so if the cells are blank I get a - (dash)? Thanks
  • 3. problem with replicate formula
    When i replicate a formula the formula is correctly changed using relative cell addressing, however rather than calculating the new value it copies the original value.
  • 4. where can i find Formulas for excel 2000?
    i have made a spreadsheet for work.. now they want me to find a way so that they can find out how many people came from a certain ward.. there are 300 people on the list and they add on more everyday! what do i do?

Vlookup doesn't work in new workbook

Postby a2xlaXZha2F0 » Thu, 08 Jun 2006 05:17:01 GMT

Here's the formula that I copied from a previous workbook that worked just 
fine.  I copied it into a new workbook, and it doesn't work.  As far as I can 
tell, all the files are in the same place, nothing has been renamed or moved 
or changed.  Any suggestions as to why this isn't working in a new workbook:

=VLOOKUP(I2,'C:\Document and settings\k.smith\My Documents\ABCD\ABCD 
Reporting\[VENDOR PRODUCT LINES LIST.XLS]Product Lines'!$A$1:$C$492,3,FALSE)

When I copy it into a new workbook, a dialog box comes up that says "Update 
Values: Vendor Product Lines List.xls.  Clicking on that workbook doesn't 
work, nor does cancelling out.  In the cell it reads "#N/A"

Thanks for any help you can provide.



RE: Vlookup doesn't work in new workbook

Postby QWxsbGxlbg » Thu, 08 Jun 2006 06:41:02 GMT

Hi, 

Can you browse through your file system from My Computer to see if that file 
VENDOR PRODUCT LINES.xls exists?

If you can't find it at all - sorry you are lost.
  
If you can find it in that exact same place, open it.  Then open your new 
workbook and put the formula in.  It should work but it will only display the 
workbook name and not the whole filepath.

If the file exists in some other place, you will need to open it and use 
Edit > Replace to replace the C:\ ... Reporting\ with the new path, eg 
X:\share\ etc etc, so that the filepath is correct.  When you get it right, 
excel will only display the workbook name.
-- 
Allllen






Similar Threads:

1.Create a new workbook for all Unique values and new work sheets to that new workboks

I'm new to VBA and needs to achieve the following task:

I've got a workbook with one worksheet with more then 1000 rows of
data with 185 columns.
There multiple Territory Reps in column E and one/multiple Retailer on
column B. There are one/multiple retailers for each Territory Rep.

I need to create new workbook for each unique Territory_Rep and one/
multiple worksheets on this new workbook.

Finally I抣l have 5 workbooks for Territory Reps and each workbook
will have multiple worksheets for each Retailer that belongs to the
Territory Rep. Each sheet will have calculated figures that would
derived from column Sales1 and Sales2.

Data looks as bellow:

Category  Retailer_No  Retailer_Name  Status  Territory_Rep  Sales1
Sales2
Cat1         1                   Ret 1                  Acti      Rep
1                100       300
Cat1         9                   Ret 2                  Acti      Rep
2                300       100
Cat1         7                   Ret 3                  Acti      Rep
1                400       200
Cat1         4                   Ret 4                  Acti      Rep
4                100       100
Cat1         5                   Ret 5                  Acti      Rep
3                200       500
Cat1         10                 Ret 10                Acti      Rep
3                300       100
Cat1         11                 Ret 11                Acti      Rep
1                600       200
Cat2         6                  Ret 6                   Acti      Rep
2                800       700
Cat2         2                  Ret 7                   Acti      Rep
5                500       500

Sort the table by Territory Rep as below:

Category  Retailer_No  Retailer_Name  Status  Territory_Rep  Sales1
Sales2
Cat1         1                   Ret 1                  Acti      Rep
1                100       300
Cat1         7                   Ret 3                  Acti      Rep
1                400       200
Cat1         11                 Ret 11                Acti      Rep
1                600       200
Cat1         9                   Ret 2                  Acti      Rep
2                300       100
Cat2         6                  Ret 6                   Acti      Rep
2                800       700
Cat1         5                   Ret 5                  Acti      Rep
3                200       500
Cat1         10                 Ret 10                Acti      Rep
3                300       100
Cat1         4                   Ret 4                  Acti      Rep
4                100       100
Cat2         2                  Ret 7                   Acti      Rep
5                500       500

Then create:
	Workbook "Rep 1 13-02-2008.xls"
	      Worksheets "Ret 1", "Ret 3", and "Ret 11"
			On each sheet insert a calculated value from the main sheet
			e.g. Sales1 + Sales2

	Workbook "Rep 2 13-02-2008.xls"
		Worksheets "Ret 2" and "Ret 6"

	Workbook "Rep 3 13-02-2008.xls"
		Create Worksheets named: "Ret 5" and "Ret 10"

	Workbook 4 = "Rep 4 13-02-2008.xls"
		Worksheets named: "Ret 4" and "Ret 8"

	Workbook 5 = "Rep 3 13-02-2008.xls"
		Worksheet named: "Ret 7"


Nazmul

Thanks in advance

2.vlookup:suddenly doesn't work for half the rows in the same wk.bk

I have a vlookup retrieving info from another page in the same workbook. To 
make things easy I copy the first row of formulas to the rows below and it 
works up to a ceratin row, and the I get #N/A. The error description is 
"Inconsistent formula" and the trace has a line from the lookup value to the 
cell next to it and then a dotted line to another cell two rows up. 
I have no clue why there is this difference - I have changed cell formats 
both on the source page and in my report page; the formula is the same as the 
rows above (they work, btw) so what is the problem with the rest of the rows?
Any comments or suggestions?

3.vlookup:suddenly doesn't work for half the rows in the same wk

Hi,
You're right I haven't used absolutes. 
I have a source page with information for a project within the same row (to 
the right of the project number). Then the range of the whole sheet is named 
Calculatie.
So the formula on the report sheet is 
     =if(A3=0;"";VLOOKUP(A3;calculatie;3;false))

This formula is the same for each cell below including the one containing 
#N/A except of course the lookup value is different because it is a new row.

I considered the fact that the problem info may fall outside of the named 
range, but I renamed it and re-enterd the VLOOKUP formula and still no joy.

So, any ideas?
Rochelle


"Niek Otten" wrote:

> Please post your initial formula and the first one giving #NA.
> I guess that the reference to the table is relative instead of absolute, 
> something like A1:A100 instead of $A$1:$A$100.
> 
> -- 
> Kind regards,
> 
> Niek Otten
> 
> "Rochelle" < XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> >I have a vlookup retrieving info from another page in the same workbook. To
> > make things easy I copy the first row of formulas to the rows below and it
> > works up to a ceratin row, and the I get #N/A. The error description is
> > "Inconsistent formula" and the trace has a line from the lookup value to 
> > the
> > cell next to it and then a dotted line to another cell two rows up.
> > I have no clue why there is this difference - I have changed cell formats
> > both on the source page and in my report page; the formula is the same as 
> > the
> > rows above (they work, btw) so what is the problem with the rest of the 
> > rows?
> > Any comments or suggestions? 
> 
> 
> 

4.vlookup doesn't work consistently (I think), kindly help

I am using VLOOKUP() to pull out a column value from a range of data. Here is 
the problem: 
When I use this fn on the same page as the referenced range, it works fine. 
For example, 
=VLOOKUP(L2,A2:I18,5) looks up the value in L2, finds it in the first column 
and returns the 5th column data... BUT

=VLOOKUP(G6,'Master Prep List'!A2:I18,5) where G6 represents a value found 
in the same range on a different worksheet, here Master Prep List,  returns 
#N/A.

This does not seem correct to me, unless I am not using the fn correctly, 
which is always a possibility. I am using Excel 2007,

Any help/insight would be appreciated. 

5.vlookup doesn't work

I am unable to do a vlookup between different workbooks.  I does however work 
within the same workbook.  Is their something I need to do to turn this 
functionality on.
-- 
Thanks
Michelle

6. vlookup doesn't always work in this situation

7. Error trapping for VLOOKUP...doesn't work so help!

8. Vlookup doesn't work until i edit(but not change) the lookup cell



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 7 guest