Results 1 to 2 of 2

Thread: Need help pulling values from column - hlookup?

  1. #1

    Need help pulling values from column - hlookup?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all, so here's my issue.. I need to pull certain values from a single column. The column is formatted so that Product ID's are typically on the top row and the UPC is located on the row directly below (not all Product ID's have UPC codes below them but I need to grab all the ones that do). This column continues on this way for thousands of rows. I need to use my list of Product ID's in Column A to run a lookup and pull the UPC value on the row directly below the ID inside Column B (some will return the next Product ID if a UPC does not exist but I can filter these out later).


    Here is an example of my sheet:


    Column A:


    IDNUM111
    IDNUM222
    IDNUM333
    IDNUM444
    IDNUM555


    Column B:


    IDNUM111
    000111
    IDNUM222
    IDNUM333
    IDNUM444
    000444


    Column A and B are in no particular order. I need some way to run a lookup based on the ID values in Column A and return the row directly below this value in Column B. I'm currently using the hlookup formula =HLOOKUP(A2, $B$2:$B$37960,2,FALSE) but this only returns the first UPC value and then stops. I need this to continue searching down all of my lookup value rows.


    Any help would be much appreciated!

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,755
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Something like =INDEX(sheet2!$B$1:$b$100,match($A1,$b$1:$b$100,0)+1) - Adapt ranges as needed and pull down

Tags for this Thread

Posting Permissions

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