Excel related

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: 205 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

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details