Dear Sir
Data is not change because the data value is same in both the sheet for
Zincmini. If we change the value in 61212 sheet the data will be change.
Rgds
Rajesh
On Friday, December 14, 2012 2:18:03 PM UTC+5:30, amar takale wrote:
>
> Dear Swapnil,
>
> Formula is good,but if I change sheet na
Hello Swapnil
Thanks for your Help.
Rgds
Rajesh
On Thursday, December 13, 2012 4:04:34 PM UTC+5:30, Swapnil Palande wrote:
>
> Hi Rajesh,
>
> You can use "Indirect" function
>
> =VLOOKUP(A2,INDIRECT("'[bcm.xls]" & L2 & "'!$A:$B"),2,0)
>
> Pls find attach solution.
>
> Regards,
>
> Swapni
