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).