Excel related

dharmesh (JOB) (34 Points)

08 November 2017

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.

Reply
Follow
Share

4 Replies

CA Ankit R Momaya (Partner at Bhat Momaya & Associates) (2319 Points)
Replied 08 November 2017

You can use the vlookup Formula in excel. I have attached the excel file as desired

Attached File : 1705279 20171108164332 solution.xlsx downloaded: 165 times

dharmesh (JOB) (34 Points)
Replied 14 November 2017

When i added new record, results is getting changed in case of Wakaner and Vasad.

Attached File : 1219990 20171114085929 copy of 1705279 20171108164332 solution 3.xlsx downloaded: 147 times

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

Attached File : 901954 20171116005814 j.xlsx downloaded: 141 times

Start a New Discussion