EXCEL VLOOKUP FUNCTION | When switching to another doc, Function Argument window disappears?

Question

Hello!

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

Any ideas?

Kind regards.

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