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.
CA Ankit R Momaya
(Partner at Bhat Momaya & Associates)
(2304 Points)
Replied 08 November 2017
You can use the vlookup Formula in excel. I have attached the excel file as desired
dharmesh
(JOB)
(34 Points)
Replied 14 November 2017
When i added new record, results is getting changed in case of Wakaner and Vasad.
JIJO YOHANNAN
(Student CA Final )
(89 Points)
Replied 16 November 2017
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
JIJO YOHANNAN
(Student CA Final )
(89 Points)
Replied 16 November 2017
See
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
CAclubindia
