not able to work with vlookup from 2 different files

when i had opened a file having details in one sheet-1 and using vlookup funtion in another sheet-2 using data in sheet-1 this " Err:507" error is shown in the cell can some one help in this regard

Hello @rao,

It would help if you gave the entire formula that produced this error.

Err:507 indicates a “Missing Pair”; possibly a missing parenthesis or missing apostrophe in the url part of the range definition ( the 2nd argument of the VLOOKUP function).