Salam
Dear friends maine 2 files banai hain.. file 1 main maine formula lagaya hai vlookup ka jo k data match ker raha hai file 2 se.

magar problem yeh hai ke file 1 main maine jahan formula lagaya hai wahan
"#value" likha hua ata hai jab file 2 open nahin hoti. or jab file 2 open kerta hon tu fir match data show kerta hai.. main chahta hon k jo data match ho rahi hai woh waisi he rahy chahy file 2 close bhi ker don..

agar kisi ko koi tareqa ya famula pata hai tu please bataiye..
Thanks