Home |
Search |
Today's Posts |
#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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |