Hopefully an easy question

[Yookaroo]

I have two sheets that I need to merge together, both have a common first row
called SORT ORDER with fields E-00001 up to E-07000.

I need to merge them without screwing up the order the first sheet is in, as
its not something that can be auto sorted.

I need to bring the data from Sheet B which is in columns L to AP into a
Sheet A starting at column M using the SORT ORDER column

Thanks in advance

 

[Bernard Liengme]

For both Sheets: What column has the SORT ORDER ?
Can duplicates exist? How should they be handled?
You may find Chip has an answer at
http://www.cpearson.com/excel/duplicat.htm
best wishes

 

[Yookaroo]

Both sheets use column A as the sort order, there are no duplicates in these
lists, both are numbered from 1 to 7000, chips site just explains duplicates
or am I missing something?

So in my case if sheet B's column A matches sheetA's Column A then I need to
copy Columns L to AP for that row and insert it at column M into SheetA.

How can I write that as a formula?

 

[Yookaroo]

Both sheets use column A as the sort order, there are no duplicates in these
lists, both are numbered from 1 to 7000, chips site just explains duplicates
or am I missing something?

So in my case if sheet B's column A matches sheetA's Column A then I need to
copy Columns L to AP for that row and insert it at column M into SheetA.

How can I write that as a formula?

 

[Bernard Liengme]

Sound like VLOOKUP should do what you want
Debra has a good explanation @
http://www.contextures.com/xlFunctions02.html
best wishes