+ Reply to Thread
Results 1 to 5 of 5

How to use VLOOKUP to match the data?

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    33

    How to use VLOOKUP to match the data?

    Hi Everybody,
    I have attached one excel sheet which is having two sheets named as Predata and Problem.
    In Predata sheet it has two columns named as Keyword and URL.
    In Problem sheet it has two columns named as Keyword1 and URL1 but URL1 is empty which need to be filled using VLOOKUP.
    The keywords which are present in Predata are also present in Problem sheet.
    So my question is how to use VLOOKUP to fill the empty column URL1 with respective urls from Predata sheet.
    For other keyword it should show "N/A" or blank.

    Please find the excel sheet to see the problem.

    Any suggestions or help is highly appreciated.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: How to use VLOOKUP to match the data?

    Put this in B2 on 'Problem' sheet and fill down:

    =IFERROR(VLOOKUP(A2,PreData!$A$2:$B$15,2,0),"")

    - Moo

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: How to use VLOOKUP to match the data?

    If you want N/A to appear, instead of a blank when there is no match, you can use:

    =IFERROR(VLOOKUP(A2,PreData!$A$2:$B$15,2,0),"N/A")

    - Moo

  4. #4
    Registered User
    Join Date
    11-21-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: How to use VLOOKUP to match the data?

    Quote Originally Posted by Moo the Dog View Post
    Put this in B2 on 'Problem' sheet and fill down:

    =IFERROR(VLOOKUP(A2,PreData!$A$2:$B$15,2,0),"")

    - Moo
    Thank you so much for your quick reply. It worked fine.

    Have a great day.

    Regards
    Kalu Charan

  5. #5
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: How to use VLOOKUP to match the data?

    You're welcome, Kalu. Glad I could help... and thanks for the rep!

    - Moo

+ Reply to Thread

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