search, match and replace, link to another sheet

J

Jon

Hi I have a big problem! I spent 2 months putting
together a database and somehow one of my columns has
shifted. I have an old database to relate to but the
information is not in the same order as mine. New db has
the bad column in it. What I need to do is look up a
column in the new db(A), match the individual cells to
cells in the old db(B), and once found grab the info from
the cell next to (B), which I will call (C) for now, and
replace the value in the field next to (A) where the
search originated, we'll call that (D). The database has
2555 entries in it that need rectifying and I'm sure there
must be an easier way than just find, cut, past for each
entry. Please help, my reference for a new job relies on
this!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wildcard issue for Index/Match Function when searching numbers 1
Create if partial match then copy and paste data from one cell to another 1
trouble with (complicated) vlookup searching another workbook 2
=MATCH with nested arrays assistance needed 0
How to do an IF statement that copy data based on a partial match 0
adding multiple values from matched search results 3
Index and Match 8
Copy cells to different sheet if value found 1

Top