| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Path to Lookup from another document
Hi, first post ever ever! Can you help? When using worksheet "A" I want an equation to look at one cell reference in worksheet "B" searching for same reference and pull information through. Worksheet "B" may not be open when lookup needs to operate. -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path to Lookup from another document
Open workbook B.
Goto workbook A. In your cell, type = then Ctrl-F6 to get to workbook, select the cell, then Enter. Workbook A will update the path when workbook B is closed. -- HTH RP (remove nothere from the email address if mailing direct) "Boethius1" wrote in message ... Hi, first post ever ever! Can you help? When using worksheet "A" I want an equation to look at one cell reference in worksheet "B" searching for same reference and pull information through. Worksheet "B" may not be open when lookup needs to operate. -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path to Lookup from another document
Bob Phillips Wrote: Open workbook B. Goto workbook A. In your cell, type = then Ctrl-F6 to get to workbook, select the cell, then Enter. Workbook A will update the path when workbook B is closed. ...................:) Wow that was a quick reply, thanks it works great BUT! with that method I am still doing the search, I want an automatic method. I have typed the following equation but it is not working, any ideas why path is wrong? =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) With this equation I am trying to look up number from C4 within the range of C4 to H41 from the file shown in path so that it will pull through the text from column 3. -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path to Lookup from another document
The syntax is incorrect - your paran is in the wrong place and you're missing
a comma: You have =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) You should have =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New Code Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3) BTW, you may want to add the final range argument to be "false" to avoid the lookup bringing in the "closest match" to the requested data. =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false) Hope this helps. -- ERR229 "Boethius1" wrote: Bob Phillips Wrote: Open workbook B. Goto workbook A. In your cell, type = then Ctrl-F6 to get to workbook, select the cell, then Enter. Workbook A will update the path when workbook B is closed. ...................:) Wow that was a quick reply, thanks it works great BUT! with that method I am still doing the search, I want an automatic method. I have typed the following equation but it is not working, any ideas why path is wrong? =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) With this equation I am trying to look up number from C4 within the range of C4 to H41 from the file shown in path so that it will pull through the text from column 3. -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path to Lookup from another document
Hi, thanks for your reply. However still can't get to work. Have simplified path to =VLOOKUP(C10,'C:\New Code Set up\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) When ask it to look it does not pull through info and deletes the C: drive and folder path from equation to leave =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) Very confusing! Thanks for the BTW but first things first! Thanks, Sharon ----------------------:) ERR229 Wrote: The syntax is incorrect - your paran is in the wrong place and you're missing a comma: You have =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) You should have =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New Code Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3) BTW, you may want to add the final range argument to be "false" to avoid the lookup bringing in the "closest match" to the requested data. =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false) Hope this helps. -- ERR229 "Boethius1" wrote: Bob Phillips Wrote: Open workbook B. Goto workbook A. In your cell, type = then Ctrl-F6 to get to workbook, select the cell, then Enter. Workbook A will update the path when workbook B is closed. ...................:) Wow that was a quick reply, thanks it works great BUT! with that method I am still doing the search, I want an automatic method. I have typed the following equation but it is not working, any ideas why path is wrong? =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) With this equation I am trying to look up number from C4 within the range of C4 to H41 from the file shown in path so that it will pull through the text from column 3. -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path to Lookup from another document
That's because the workbook you lookup in is open, if you close it you'll
get the full path -- Regards, Peo Sjoblom Portland, Oregon "Boethius1" wrote in message ... Hi, thanks for your reply. However still can't get to work. Have simplified path to =VLOOKUP(C10,'C:\New Code Set up\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) When ask it to look it does not pull through info and deletes the C: drive and folder path from equation to leave =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) Very confusing! Thanks for the BTW but first things first! Thanks, Sharon ----------------------:) ERR229 Wrote: The syntax is incorrect - your paran is in the wrong place and you're missing a comma: You have =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) You should have =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New Code Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3) BTW, you may want to add the final range argument to be "false" to avoid the lookup bringing in the "closest match" to the requested data. =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false) Hope this helps. -- ERR229 "Boethius1" wrote: Bob Phillips Wrote: Open workbook B. Goto workbook A. In your cell, type = then Ctrl-F6 to get to workbook, select the cell, then Enter. Workbook A will update the path when workbook B is closed. ...................:) Wow that was a quick reply, thanks it works great BUT! with that method I am still doing the search, I want an automatic method. I have typed the following equation but it is not working, any ideas why path is wrong? =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3) With this equation I am trying to look up number from C4 within the range of C4 to H41 from the file shown in path so that it will pull through the text from column 3. -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=501503 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel saves the path of the printer with the document. | Excel Discussion (Misc queries) | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Hybrid Mode
