| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup data in other workbook
hi.
i want to know if it possible get values to a sheet from another workbook sheet. How i can do this. Thanks! |
|
#2
|
|||
|
|||
|
Lookup data in other workbook
Yes it is. You either link directly
=[Timesheet.xls]Summary!$A$2 or evne use VLOOKUP =VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE) -- HTH RP (remove nothere from the email address if mailing direct) "Pasmatos" wrote in message ... hi. i want to know if it possible get values to a sheet from another workbook sheet. How i can do this. Thanks! |
|
#3
|
|||
|
|||
|
Lookup data in other workbook
Thanks, Bob.
Best Regards. "Bob Phillips" wrote: Yes it is. You either link directly =[Timesheet.xls]Summary!$A$2 or evne use VLOOKUP =VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE) -- HTH RP (remove nothere from the email address if mailing direct) "Pasmatos" wrote in message ... hi. i want to know if it possible get values to a sheet from another workbook sheet. How i can do this. Thanks! |
|
#4
|
|||
|
|||
|
Lookup data in other workbook
Sorry, I think that its over but all the time i edit the formula she excel
ask the path for the excel file that i want to vlookup Thanks! "Bob Phillips" wrote: Yes it is. You either link directly =[Timesheet.xls]Summary!$A$2 or evne use VLOOKUP =VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE) -- HTH RP (remove nothere from the email address if mailing direct) "Pasmatos" wrote in message ... hi. i want to know if it possible get values to a sheet from another workbook sheet. How i can do this. Thanks! |
|
#5
|
|||
|
|||
|
Lookup data in other workbook
I am not sure what you mean. Can you clarify?
-- HTH RP (remove nothere from the email address if mailing direct) "Pasmatos" wrote in message ... Sorry, I think that its over but all the time i edit the formula she excel ask the path for the excel file that i want to vlookup Thanks! "Bob Phillips" wrote: Yes it is. You either link directly =[Timesheet.xls]Summary!$A$2 or evne use VLOOKUP =VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE) -- HTH RP (remove nothere from the email address if mailing direct) "Pasmatos" wrote in message ... hi. i want to know if it possible get values to a sheet from another workbook sheet. How i can do this. Thanks! |
|
#6
|
|||
|
|||
|
Lookup data in other workbook
Thanks for your help. But your post resolve my problem.
Regards. Paulo "Bob Phillips" wrote: I am not sure what you mean. Can you clarify? -- HTH RP (remove nothere from the email address if mailing direct) "Pasmatos" wrote in message ... Sorry, I think that its over but all the time i edit the formula she excel ask the path for the excel file that i want to vlookup Thanks! "Bob Phillips" wrote: Yes it is. You either link directly =[Timesheet.xls]Summary!$A$2 or evne use VLOOKUP =VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE) -- HTH RP (remove nothere from the email address if mailing direct) "Pasmatos" wrote in message ... hi. i want to know if it possible get values to a sheet from another workbook sheet. How i can do this. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Lookup thinks data isn't sorted | Excel Worksheet Functions | |||
| Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
| Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Linear Mode
