compare two columns and output to new column
Results 1 to 3 of 3

Thread: compare two columns and output to new column
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2015
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default compare two columns and output to new column

    I am trying to compare an address on sheet A with an address on sheet B and if they match put data from column E on sheet 2 into column H on sheet 1.

    Here is the formula I have that is not working.
    =VLOOKUP(F2,ActiveCustomerListing!$D$2:$E$36000,3,0)

    Column F on sheet 1 is an address
    Column D on sheet 2 is an address
    Column E on sheet 2 is a phone number


    Thanks for any help.

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    219
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: compare two columns and output to new column

    ExcelTom,

    It looks like your col_index_num is one column too far. You are only indexing into columns D & E so the max should be 2.

    Try
    =VLOOKUP(F2,ActiveCustomerListing!$D$2:$E$36000,2,0)

  3. #3
    Board Regular
    Join Date
    May 2015
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: compare two columns and output to new column

    Thanks. That was the problem.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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