View Single Post
  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default 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!