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
Bookmarks