If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup
Hello,
Is there a way to use a lookup function to another Excel File. I use Vlookups and Hlookups in a single workbook, often. Is there a similar function that allows the ability to lookup to another file. My basic problem is: I need to pull the total values of one file into another, but the total rows will change and move down the page as new line items are added. This causes a problem if I just do a basic "=" formula to the other file. Any suggestions? Thank You, |
#2
|
|||
|
|||
Can't you just use a larger table so it will always will house whatever rows
you add? Regards, Peo Sjoblom "tjh" wrote: Hello, Is there a way to use a lookup function to another Excel File. I use Vlookups and Hlookups in a single workbook, often. Is there a similar function that allows the ability to lookup to another file. My basic problem is: I need to pull the total values of one file into another, but the total rows will change and move down the page as new line items are added. This causes a problem if I just do a basic "=" formula to the other file. Any suggestions? Thank You, |
#3
|
|||
|
|||
Yes, but the lookup will not work between workbooks/Files. Will it???
"Peo Sjoblom" wrote: Can't you just use a larger table so it will always will house whatever rows you add? Regards, Peo Sjoblom "tjh" wrote: Hello, Is there a way to use a lookup function to another Excel File. I use Vlookups and Hlookups in a single workbook, often. Is there a similar function that allows the ability to lookup to another file. My basic problem is: I need to pull the total values of one file into another, but the total rows will change and move down the page as new line items are added. This causes a problem if I just do a basic "=" formula to the other file. Any suggestions? Thank You, |
#4
|
|||
|
|||
Yes, both h and vlookup will work with other files that are closed, it's
easier to open the other files when you build the formula since you can just use the mouse and click, then you can close the files with the tables and Excel will automatically return the full path, example formula when the table workbook is open =VLOOKUP(A1,[Telephones.xls]Phones!$A$2:$B$36,2,0) then when I close the telephones file =VLOOKUP(A1,'C:\Documents and Settings\Peo Sjoblom\My Documents\Excel Documents\[Telephones.xls]Phones'!$A$2:$B$36,2,0) but it still works so if you change the lookup value in A1 it will return a value if it finds a match -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "tjh" wrote in message ... Yes, but the lookup will not work between workbooks/Files. Will it??? "Peo Sjoblom" wrote: Can't you just use a larger table so it will always will house whatever rows you add? Regards, Peo Sjoblom "tjh" wrote: Hello, Is there a way to use a lookup function to another Excel File. I use Vlookups and Hlookups in a single workbook, often. Is there a similar function that allows the ability to lookup to another file. My basic problem is: I need to pull the total values of one file into another, but the total rows will change and move down the page as new line items are added. This causes a problem if I just do a basic "=" formula to the other file. Any suggestions? Thank You, |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup fields on label report | Howard | Setting Up & Running Reports | 1 | June 3rd, 2004 02:43 AM |
Make a field lookup dependent on the value in another field of a record? | Susan A | Database Design | 8 | May 22nd, 2004 09:10 PM |
Lookup fields - what's wrong with them? | NATHAN SANDERS | New Users | 2 | May 4th, 2004 10:51 AM |
Confusion on LOOKUP function | Walter Mayes | Worksheet Functions | 5 | April 16th, 2004 10:12 PM |
multiple-condition lookup | Jocelyn | Worksheet Functions | 4 | February 26th, 2004 09:42 PM |