MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formulas - vlookup in a database query

Posted by K Robinson on January 21, 2002 8:56 AM

I keep getting an error msg when trying to create a vlookup formula. the formula reads as follows: Vlookup(d2,Sheet3!ExternalData,2) The only thing that happens when I do this formula the msg is saying: file not found.

1st can you tell me what the different arguments mean in the above formula....what am I asking, I got this formula from some instructions but I am not certain what I am asking.

I have created a query from a program and I am trying to create a report. From this report what I need from the system I have put in the spreadsheet I am creating. I am getting info from one worksheet to put in another worksheet.

I figure if I can understand what the arguments mean then maybe I can figure where my mistake is.

Posted by BJ on January 21, 2002 9:02 AM

Try, =vlookup(D2, sheet3!A:B, 2,false)

Posted by Sam S on January 21, 2002 7:05 PM

The syntax is
which is found in Help also use the Paste Function (fx) on your tool bar to help guide you.

In reality though you haven't named the external file correctly.