Vlookup accross multiple saved documents

**izelle** · 07-12-2011, 08:04 AM

I have 2 saved excel documents and want to do a vlookup. I can do vlookups normally when the data is all in 1 saved document. When I try to select in the table array field the second saved document, I am unable to select any data to search. it goes to the second saved sheet, but the vlookup block is not present so that I can choose the relevant columns in the second saved document. I thought originally that it was a compatability issue between 97 and 2007, but it is not the case as I saved both these documents as 2007 doc.

Please I need urgent assistance on how to get past this issue.

**JBeaucaire** · 07-12-2011, 09:29 AM

Let's see you're current non-working formula. Doing a VLOOKUP on a second document is simple, doing it in two would require some sort of IF/THEN logic you haven't described yet, so we need to see what you're really trying to do.

**izelle** · 07-12-2011, 10:06 AM

I have 2 save sheets
sheet 1.xlsx
sheet 2.xlsx

I've opened both the sheets.

I am doing a vlookup in sheet 1.xlsx as follows:

Lookup_Value:A:A
Table_array:here I want to refer to data saved on sheet 2.xlsx. When I click on sheet 2.xlsx to highlight the columns I want to use, the Fuction Argument box does not appear in sheet 2.xlsx to be able to select data required.

I can do the above on my laptop, but on my personal laptop I am not able to do this.

Let me know if you need more info.

**JBeaucaire** · 07-12-2011, 11:27 AM

You can type the workbook name in [ ] braces and then the sheet name and then the column reference by hand.

=LOOKUP(A1, [Workbook2.xls]Sheet2!A:A, [Workbook2.xls]Sheet2!B:B)

I won't be a lot of help troubleshooting your local computer.

**mikikiki** · 07-20-2011, 01:31 PM

Hello my friend,

As with the infamous Office validation update that caused issues with opening files on network shares for excel 2003, this bug you're referring to was caused by the latest excel 2003 update, just go to the add/remove programs list, check for the latest office 2003 excel component update, and remove it.