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 this issue.
As it is, I'll see what I can do for you here.
Jump to PostYou can use vlookup function for the same purpose
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.