Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
can i use hlookup to find data in another file?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes, but the second file needs to be open.
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "rmaris" wrote in message ... can i use hlookup to find data in another file? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Why does the second file need to be open?
Bernard Liengme wrote: Yes, but the second file needs to be open. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "rmaris" wrote in message ... can i use hlookup to find data in another file? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can, but the file will need to be opened in order to update the formulas.
"rmaris" wrote: can i use hlookup to find data in another file? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You sure?
Barb Reinhardt wrote: You can, but the file will need to be opened in order to update the formulas. "rmaris" wrote: can i use hlookup to find data in another file? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find first blank row in worksheet to import data from txt file | Excel Discussion (Misc queries) | |||
How to use HLOOKUP or other command to find a value within a range | Excel Worksheet Functions | |||
Unable to sort data in excel with cells containing if & hlookup | Excel Worksheet Functions | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel |