+ Reply to Thread
Results 1 to 6 of 6

Adding a value to a row based on two cells values

  1. 02-28-2013, 11:56 AM #1
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Adding a value to a row based on two cells values

    Hi,

    I'm trying to give a set value to column F when on the same row when in column B it contains bing.com and in column E it contains MPS001 and so on.

    Here is an example of what the required VBA may look like and I have attached a sample of the data test.xls (excel 2003).


    Please Login or Register  to view this content.
    Thanks in advance,

    David
    Attached Files Attached Files
    Last edited by djfscouse; 02-28-2013 at 12:38 PM.
    Reply With QuoteRegister To Reply
  2. 02-28-2013, 12:13 PM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Adding a value to a row based on two cells values

    maybe so (see formulas in green cells)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 02-28-2013, 12:30 PM #3
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Adding a value to a row based on two cells values

    Thanks nilem, do you have a VBA version?

    David
    Reply With QuoteRegister To Reply
  4. 02-28-2013, 02:14 PM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Adding a value to a row based on two cells values

    Maybe:

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 02-28-2013 at 02:18 PM.
    Reply With QuoteRegister To Reply
  5. 02-28-2013, 02:22 PM #5
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Adding a value to a row based on two cells values

    Exactly right! Thanks John.
    Reply With QuoteRegister To Reply
  6. 02-28-2013, 02:35 PM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Adding a value to a row based on two cells values

    You're welcome. Glad to help out and thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1