Results 1 to 4 of 4

Matching 2 fields in 2 columns and copying a 3rd field into the 3rd column

Threaded View

krenejones Matching 2 fields in 2... 10-08-2009, 01:06 PM
NBVC Re: Matching 2 fields in 2... 10-08-2009, 01:10 PM
krenejones Re: Matching 2 fields in 2... 10-08-2009, 01:57 PM
NBVC Re: Matching 2 fields in 2... 10-08-2009, 02:22 PM
  1. #1
    Registered User
    Join Date
    10-08-2009
    Location
    Ventura, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Red face Matching 2 fields in 2 columns and copying a 3rd field into the 3rd column

    Hi All,

    I'm new to Excel...I'm sure you've read that enough times on this forum.

    I need help with a formula. Probably Vlookup. I'm having a LOT of trouble trying to figure out how to "phrase" the formula so let me explain what it is I'm trying to do.

    If a cell in Sheet 1 Column AS and a cell in Sheet 2 Column B match exactly, I want the cell in Sheet 2 Column C that is in the same row as the matched cell in Sheet 2 Column B to be copied into Sheet 1 Column BB in the same row as the matched cell in Sheet 1 Column AS.

    For example, if cells in S1 Column AS and S2 Column B both have the name "LOS ANGELES" then "KLAX" will be copied from cell in S2 Column C (in same row as "LOS ANGELES") to S1 Column BB (in same row as "LOS ANGELES").

    Oh my, I hope that was clear enough. Please help me!
    Last edited by krenejones; 10-08-2009 at 02:31 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1