Vlookup when you have two screens

[psrs0810]

I am running into a problem doing a vlookup with two screens. I have two excels open - one on the left and the other on the rights. When I type in my vlookup formula and go to reference the other excel, the formula stops filling in.

how to I get around this

 

[zakasnak]

You have to have both spreadsheets open in the same instance of Excel.

You can arrange them in the same window so you can see both.......

 

[psrs0810]

well that's no fun