Lookup data in other workbook

P

Pasmatos

hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!
 
B

Bob Phillips

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)
 
P

Pasmatos

Thanks, Bob.
Best Regards.

Bob Phillips said:
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 said:
hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!
Click to expand...
Click to expand...
 
P

Pasmatos

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 said:
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 said:
hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!
Click to expand...
Click to expand...
 
B

Bob Phillips

I am not sure what you mean. Can you clarify?

--

HTH

RP
(remove nothere from the email address if mailing direct)


Pasmatos said:
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 said:
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 said:
hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!
Click to expand...
Click to expand...
Click to expand...
 
P

Pasmatos

Thanks for your help. But your post resolve my problem.

Regards.
Paulo

Bob Phillips said:
I am not sure what you mean. Can you clarify?

--

HTH

RP
(remove nothere from the email address if mailing direct)


Pasmatos said:
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 said:
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)


hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Top