lookup data in a different workbook

  • Thread starter Thread starter dlaery
  • Start date Start date
D

dlaery

I export a list of items from Quickbooks.
Quickbooks will export as a xls file.
I want to create a different worksheet or workbook that will look u
data in this file. I need to find data in a certain column in a certai
row. So when my data changes in Quickbooks, I export the file, and the
in another workbook or worksheet, update, based on the new or update
data. I have tried the lookup wizard but it will not let me use
different worksheet or workbook. I can make it work in the sam
worksheet.
So what I'm looking for is a direction where to start. I have made man
complex Excel worksheets, using macros and formulas that I get fro
here. But I can't seem to figure out how to accomplish this one.

Thanks,
Davi
 
Try this:

assuming that you are looking up the value in C1 in a file called export.xls
that is saved in your Data folder on your default drive. Also assume that
you have named the range that is being looked up as "codeslookup" and you
want the formula to return the information in the 3rd column ...


VLOOKUP(C1,'\\Data\export.xls'!codeslookup,3)

Alternatively, if you have both files open, you can use the wizard - just
click on the little "choose cell(s)" symbol to the right of the field in the
wizard, then click on the other file and the appropriate range, then click
again on the choose cell(s) symbol to be returned to the worksheet and cell
you are working in.

I hope this helps you.

Bonnie
 
Back
Top