Greetings from India,
Have two different worksheets containing
1. Production details.
2. Delivery details.
want to combine them as one but cannot use Vlookup as the both worksheet has the same item a number of times.
could anyone explain anyother method or formula.
did notice sometime before about a thread mentioning all occurances. but cannot see it now.
thanks.
Check out this thread, hopefully it can help you
http://www.excelforum.com/excel-gene...l-results.html
Greetings Davesexcel,
Thanks for the suggestion and have seen the post.
well am learning a lot of excel from you all.
forum members have all been quite generous.
thanks, Lord bless.
<SOLVED>
is this way to close the post?
thanks.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
marked solved, as OP cannot see edit button anymore.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks