Hi, Need Help on Vlook Up in Excel 2007:-
A Case is assigned to Person 1 (Column B) ...As a back up it is sometimes assigned to Person 2 (Column C) So if Case ID is in Column A , there is always name of Person in Column B. But only some cases are Assigned Person 2 in Column C. I want to lookup both these columns in another Sheet. This another Sheet has Names of these Persons and their Respective Departments. I want to write a Vlookup Function which first returns Department for Person 1 . If Person 1 is not available in another Sheet, it should do lookup for Person 2 in this sheet and return the department. if both Persons 1 and Person 2 are not available in the lookup table (Another Sheet), it can return # N/A Please help. On Tue, Jul 24, 2012 at 5:55 AM, <excel-macros@googlegroups.com> wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - Company Name in front of Show its > sector<#138b6602a29a6d52_group_thread_0>[1 Update] > - Macro - Copy Range and Open Outlook Draft and > Paste<#138b6602a29a6d52_group_thread_1>[1 Update] > - need to consolidate data in one > sheet<#138b6602a29a6d52_group_thread_2>[1 Update] > - Submit data into web forms <#138b6602a29a6d52_group_thread_3> [1 > Update] > - Paste Special With transpose and links to the source > data<#138b6602a29a6d52_group_thread_4>[2 Updates] > > Company Name in front of Show its > sector<http://groups.google.com/group/excel-macros/t/d7c8a2e8b0c7231e> > > "dguillett1" <dguille...@gmail.com> Jul 23 04:23PM -0500 > > You need to send ME a FILE showing EXACTLY what you want.... > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > From: amar takale > Sent: Thursday, July 19, 2012 11:58 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Company Name in front of Show its sector > > I used this code But not work. Which I send second file sample 1 Use > it & put code. > If I put code & run code not work. Y also try.My answer in sheet like > > H D F C Bank Ltd. Bank > > State Bank Of India Bank > > > Tata Steel Ltd. Metals & Minerals > > Sterlite Industries (India) Ltd. Metals & Minerals > > > Mahindra & Mahindra Ltd. Auto > > Maruti Suzuki India Ltd.Auto > > > On Thu, Jul 19, 2012 at 6:39 PM, dguillett1 <dguille...@gmail.com> > wrote: > > You asked for a macro and I provided one that did work with your > example. Please fully explain. > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > From: amar takale > Sent: Thursday, July 19, 2012 7:59 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Company Name in front of Show its sector > > Code is not work.I will Sent file You will work with below code.I use > but not work.There are any formula? > > > On Thu, Jul 19, 2012 at 6:09 PM, dguillett1 <dguille...@gmail.com> > wrote: > > Should work > > Option Explicit > Sub groupsSAS() > Dim mr As Range > Dim b As Range > Dim sr As Long > Rows(2).Insert > Set mr = Cells(2, "b") _ > .Resize(Cells(Rows.Count, "b").End(xlUp).Row) > For Each b In mr.SpecialCells(xlBlanks) > sr = b.Offset(-1).End(xlUp).Row > Cells(sr, "c") _ > .Resize(b.Row - sr + 1).Value = Cells(sr, "b") > Next b > End Sub > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > From: amar takale > Sent: Thursday, July 19, 2012 5:54 AM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Company Name in front of Show its sector > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > > To unsubscribe, send a blank email to mailto: > excel-macros%2bunsubscr...@googlegroups.com > > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > > To unsubscribe, send a blank email to mailto: > excel-macros%2bunsubscr...@googlegroups.com > > > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to mailto: > excel-macros%2bunsubscr...@googlegroups.com > > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to mailto: > excel-macros%2bunsubscr...@googlegroups.com > > > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > Macro - Copy Range and Open Outlook Draft and > Paste<http://groups.google.com/group/excel-macros/t/d5b2cb9cd8ccc75c> > > "John A. Smith" <johnasmit...@gmail.com> Jul 23 02:31PM -0400 > > That was it. I will go over this with a fine tuned comb and learn all I > can. Thank you most graciously for your much appreciated help. > > John > > > > > need to consolidate data in one > sheet<http://groups.google.com/group/excel-macros/t/22a2eaefd7e20633> > > "B.N.Chethan Kumar" <chetankumar1...@gmail.com> Jul 23 06:41AM -0500 > > Hi Don, > > kindly explain how did you do that. > > Regards > CK > > > -- > B.N Chetan kumar > > > > Submit data into web > forms<http://groups.google.com/group/excel-macros/t/ef2034f2167c9e13> > > Karan Singh <karan1...@gmail.com> Jul 23 04:43PM +0530 > > Dear Friends, > > I need to take data stored in Excel files and populate (copy and paste > ) > the data into web forms, submit the form then loop through the enitre > process until I have gone through the entire Excel file. Is there any > option in excel to perform this task? Please help me in this. > Thanks > Karan Singh > > > > Paste Special With transpose and links to the source > data<http://groups.google.com/group/excel-macros/t/9263483b35e95b1> > > "P.VIJAYKUMAR" <vijay.4...@gmail.com> Jul 23 06:51AM +0530 > > Dear Excel Experts, > > When I try to paste special some data with links to the source sheet > and > also want the the data to be transposed.The same is not happening > because > transpose is getting disabled if paste links is selected.Is there any > other > solution to the problem? > > > > > Regards, > P.VIJAY KUMAR > > > > > Anil Gawli <gawlianil8...@gmail.com> Jul 23 10:19AM +0530 > > dear Vijay > Transpose is done only in same file not in another file. > first of all copy the source data. > Then Paste it in another file and then from there transpose it. > > Regards, > Gawli Anil > > On Mon, Jul 23, 2012 at 6:51 AM, P.VIJAYKUMAR <> wrote: > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > > > You received this message because you are subscribed to the Google Group > excel-macros. > You can post via email <excel-macros@googlegroups.com>. > To unsubscribe from this group, > send<excel-macros+unsubscr...@googlegroups.com>an empty message. > For more options, > visit<http://groups.google.com/group/excel-macros/topics>this group. > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
