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
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
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.