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.