+ Reply to Thread
Results 1 to 2 of 2

Need help copying HLOOKUP down entire column of lookup values

  1. #1
    Registered User
    Join Date
    10-16-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    1

    Need help copying HLOOKUP down entire column of lookup values

    Here's my predicament.. I have a spreadsheet with product data mashed into a single column that I'm trying to separate and clean up. Product ID's are stacked directly on top of product UPC codes inside the same column. I have a list of Product ID's in a different sheet that I need to use as look up values and pull out the UPC's. The column is currently arranged like this:

    Column A (Sheet1):

    Product-001
    000111
    Product-002
    000222
    Product-003
    000333

    ...and so on for several thousand lines. The UPC's I need are always located 1 row below the corresponding Product ID. Currently my hlookup formula only returns the very first UPC code from my lookup values. I need this formula to continue down my list of Product ID's and return all UPC codes.

    Here is my formula so far:

    =HLOOKUP(A2, SHEET1!$A$1:$A$37961,2,FALSE) I copy this formula down my list of Product ID's but only the first UPC in the table array is returned.

    Can anyone help? Is there a better method for this other than HLOOKUP?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    04-15-2015
    Location
    beirut
    MS-Off Ver
    2010
    Posts
    107

    Re: Need help copying HLOOKUP down entire column of lookup values

    See this file
    Attached Files Attached Files

+ 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. Replies: 3
    Last Post: 06-28-2014, 07:04 AM
  2. Copying entire row if other column has a value of >1
    By derkieboy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2013, 07:38 AM
  3. Copying the same value into an entire column
    By seigna in forum Excel General
    Replies: 2
    Last Post: 05-11-2013, 02:53 PM
  4. Replies: 1
    Last Post: 05-09-2012, 05:30 PM
  5. copying an entire column
    By dlb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2006, 11:34 AM
  6. copying an entire worksheet - need absolute values
    By Cowtoon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2005, 06:15 PM
  7. [SOLVED] Multiple lookup values in =HLOOKUP
    By Peter in forum Excel General
    Replies: 1
    Last Post: 09-17-2005, 04:05 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