Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

1 Answer 1

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.