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.
