Thread: Create a 3rd sheet containing cells in both Sheets 1 and 2

By the way, I am a REAL BIG beginner with excel, so please provide some hand-holding in the instructions. 8-) thank you.

Or if it would be easier to have all the info on one sheet, I could put info on Sheet 2 into some columns on Sheet 1. And I do not mind having the Sheet3 data (the "pairs") onto some colum(s) on sheet 1, as well.

If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software

Presuming that there's no duplicate account numbers in either Sheet1's data or in Sheet2's data, you could try this easy formulas option to carve out the expected results In Sheet3, In A2 down, do a copy n paste of the data from Sheet1/2, one below the other (the pastes can be in any sequence). Done in 5 secs flat. Put in B2: =IF(AND(COUNTIF(A:A,A2)>=2,COUNTIF(A$2:A2,A2)<2), R OW...

oops, typo: > .. Col A will return the expected results all neatly packed at the top. It should read Col C (not Col A). But of course -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik ---

13181543

Thanks, everyone. I was able to find the solution by putting this in C2: =VLOOKUP(A2,$B$2:$B$400,1,FALSE) C3: =VLOOKUP(A3,$B$2:$B$400,1,FALSE) Column 1 had all the account numbers from one source. (last row: 348) Column 2 had all the acount numbers from a different source. (last row 311)

Thanks, everyone. I was able to find the solution by putting this in C2: =VLOOKUP(A2,$B$2:$B$400,1,FALSE) C3: =VLOOKUP(A3,$B$2:$B$400,1,FALSE) Column 1 had all the account numbers from one source. (last row: 348) Column 2 had all the acount numbers from a different source. (last row 311)