Hi,
im facing difficulty in surfing by using the data stored in two seperate fields.
For ex: for a Relay we have attached around 10 attributes such as
1.Relay Name:(Ex. NWSR)
2.Function No.:(Ex. Sh10)
3.Left Terminal No.:(Ex. A3)
4.Left Relay No.:(Ex:58)
5.Left Rack No.:(Ex:4)
Etc....
Now my requirement is i need to search a relay in a project whose relay name is "NWSR" and also whose function No. is "10" and there is every chance of same relay name present in a different sheet but definetly with a different function number along with NWSR-10 relay
Pls anybody help me out.
Thanks & Regards
Mukesh