Hi sachin
I think below link will help
Try it
https://www.dropbox.com/s/6a60ix27rhd5fip/using%20vlookup.xlsx
I give the solution with one example
thanks to excel forums for link us
To sgmpatnaik
Thank you sir
To: jason
Yes your correct But I used it in different file. This will be used many users without knowing excel options. so that only I asked
For your reference please click the below link...
@sgmpatnaik
hi
as per guidelines given by you
and I made a small correction on trial error method I reach my goal
thank you sir
https://www.dropbox.com/s/35r37x2dxy1c2f9/test%20question%202%20HIDE%20ALL%20ROWS%201.xlsm
sir
as your guidelines I try my best
but not working
if you send me your mail address I will send the file which I used
help me sir
thank you
my mail address
sivakumar6776.sr@gmail.com