VLOOKUP 2 workbooks

H

Holly

I'm trying to use VLOOKUP with two different workbooks, but I can't seem to
get it to work. I use VLOOKUP all the time with no issues, but I can't seem
to get it to work when linking two different workbooks. I have an original
workbook that we update and then one that has info copied from the original
workbook. Both have end dates and I tried using VLOOKUP in the copied file
to update the end dates to the dates in the original file (the one we
update). This is what my formula looks like:

=VLOOKUP(B2,'[A Fund List (1-20-09).xls]Fund List'!$A$2:$L$944,12,)

B2 is in the second workbook and the rest of the info is in the original
workbook. Is the problem the column index? Maybe?

Thanks for any help!
Holly
 
M

Mike H

Holly,

'I can't seem to get it to work' isn't very helpful, what result are you
getting? What result do you expect to get?

There's nothing wrong with your formula so check your data. Does b2 really
equal anything in column A of the workbook called 'A Fund List (1-20-09).xls'

Is there really a sheet called 'Fund List'?

Check for rogue spaces in column A and b2.

Mike
 
H

Holly

Mike,

The data that I'm looking for in the A-Fund list is in column B, not A. So
it works now, duh! Thank you!

Holly

Mike H said:
Holly,

'I can't seem to get it to work' isn't very helpful, what result are you
getting? What result do you expect to get?

There's nothing wrong with your formula so check your data. Does b2 really
equal anything in column A of the workbook called 'A Fund List (1-20-09).xls'

Is there really a sheet called 'Fund List'?

Check for rogue spaces in column A and b2.

Mike

Holly said:
I'm trying to use VLOOKUP with two different workbooks, but I can't seem to
get it to work. I use VLOOKUP all the time with no issues, but I can't seem
to get it to work when linking two different workbooks. I have an original
workbook that we update and then one that has info copied from the original
workbook. Both have end dates and I tried using VLOOKUP in the copied file
to update the end dates to the dates in the original file (the one we
update). This is what my formula looks like:

=VLOOKUP(B2,'[A Fund List (1-20-09).xls]Fund List'!$A$2:$L$944,12,)

B2 is in the second workbook and the rest of the info is in the original
workbook. Is the problem the column index? Maybe?

Thanks for any help!
Holly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top