Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears. Google finds some results about the problem, but nothing helpful. Following things have already been considered:

  • Security problems (Trusted center is OK, settings too)
  • File locations (excel spreadsheets are in the same folder)
  • Cells are numbers, not text
share|improve this question

migrated from Nov 10 '10 at 12:13

This question came from our site for professional and enthusiast programmers.

when you start typing the formula into the first window =vlookup(....... you must type your first paramater =vlookup(firstparameter .... then make sure to type the comma , ..... after you have typed the comma, you can now go to your other window and freely select the next parameter

share|improve this answer

You must log in to answer this question.