I want to get output from Master table by Searching word.
E.g SADHLICHA word should be search from Master table and desired output should be Vadodara.
Attached File : 1219990 20171108120541 test.xlsx downloaded: 86 times
Menu
Excel related
Attached File : 1219990 20171108120541 test.xlsx downloaded: 86 times
Replies (4)
You can use the vlookup Formula in excel. I have attached the excel file as desired
When i added new record, results is getting changed in case of Wakaner and Vasad.
Probably due to some search function issues in Vlookup in matching appropriate match
1.update vlook up function when u update master data
2.After update still it shows issue in this case prob vlookup issue appropriate match
3.Soln is u have to split the ":input colmn"' using text to colmn function and upate eqn with exact match vlookup function
See
Recent Threads
- LTCG Tax on property
- Short term gain in itr2, missing 111A
- Errors in ITR Filing: Minimum One Character Requir
- Which ITR Opt
- Employer Details for NRI
- Section 194C or 194J apply in survey fee to determ
- Accidental Switch to New Regime using Form 10-IEA
- Should I file Revised Return U/S 139 (5)?
- Voice commands for Tally ERP - would CAs find this
- ITR-2 Filing Blocked – BFLA Schedule Bug in
Related Threads
CAclubindia
