+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP from One Array to Another Array

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    13

    VLOOKUP from One Array to Another Array

    Hi all,

    A quick question...

    Is it possible to use a VLOOKUP (or HLOOKUP), to check if any one reference number in a row of reference numbers is present in another column of reference numbers.

    Then, if it is, find this particular reference number in the vertical list, and pull out the value associated with that number (in a column immediately to the right of the reference numbers)

    I hope this makes sense.

    If I had the data on my person, I would upload a screenshot, unfortunately, I don't, sorry.

    Thanks for the help

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,550

    Re: VLOOKUP from One Array to Another Array

    Screenshots are not much use anyway - better to post an Excel workbook.

    You don't say which columns you are using, so assume reference numbers in column A, starting on row 2 to allow for headers. Also assume that your other table of codes and values is in columns J and K on the same sheet, then you can put this in B2:

    =IFERROR(VLOOKUP(A2,J:K,2,0),"")

    then copy down.

    Hope this helps.

    Pete

    EDIT: Sorry, you say that the first list is in a row, so that won't work - please describe how your data is laid out.

  3. #3
    Registered User
    Join Date
    08-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: VLOOKUP from One Array to Another Array

    Pete, thanks for the help.

    Unfortunately, it isn't quite what I want to do.

    Assuming your set up (Data in table A2:H4000, and another set of codes in table J2:K2000)

    What I want is a function in cell I2, that looks across the row A2:H2 and says, right, are any of these reference numbers present in the column J2:J2000. Then, if it finds such a reference number in A2:H2, it takes the corresponding value, in column K, associated with that reference number.

    I hope this is more clear?

    Thanks
    Last edited by Delvesy888; 08-13-2013 at 12:32 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Quick Array question - Copy array to another array then resize?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-02-2013, 01:17 AM
  2. [SOLVED] Looking for a way to do a VLookup in one array, if value not there go to a second array
    By Steverizer in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-12-2013, 05:08 PM
  3. Replies: 2
    Last Post: 06-01-2011, 07:43 AM
  4. Replies: 2
    Last Post: 02-23-2011, 07:24 AM
  5. Using Vlookup to lookup array, return array
    By jcampbell in forum Excel General
    Replies: 5
    Last Post: 11-16-2007, 01:13 PM

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