If you want to create a formula using a function (like vlookup) which accesses a value in another spreadsheet, then open both spreadsheets, type the beginning of the function "+vlookup('lookupstring'," and then use window menu to switch to the other sheet, place cursor to highlight the range you you want, and place enter... this puts you back into the first sheet with a cell reading something like "+vlookup(lookupstring,'C:\Path2\File2.XLS'!$B$9:$Q$19'". Then you can finish it off by adding the column number for example "+vlookup(lookupstring,'C:\Path2\File2.XLS'!$B$9:$Q$19',3,false)"
(note all my double-quotes are to set off from my text and would not appear on your screen)
=====================================
Eng-tips forums: The best place on the web for engineering discussions.