Hi !
I have a column of 'City', now I want to compare the value of each cell of 'City' against the column 'City_Check'; the cell where the value matches, pick the value of 'City_ID' column & replace the city name with that ID in the 'City column'.
* The Image clarifies what I want(Plz see the attachments)... I have my original data file attached as well.
Regards.
fashxfreak
3
Newbie Poster
Recommended Answers
Jump to PostHi fashxfreak, daniweb is a great site but you need a help forum that deals specifically with Excel & MS Office applications. I suggest www.thecodecage.com You'll find all the help you'll need for …
Jump to PostWhat is the trigger to make this table? Do you want this to populate after each City entry?
All 5 Replies
Stuugie
50
Marketing Strategist
Stuugie
50
Marketing Strategist
fashxfreak
3
Newbie Poster
Stuugie
50
Marketing Strategist
urtrivedi
276
Nearly a Posting Virtuoso
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.