bluetubevision
New Member
- Joined
- Feb 5, 2016
- Messages
- 1
This is my first time ever to post in forum. Please forgive me if I do something wrong. Okay, here is my question.
I currently have a spreadsheet that contains roughly 10K rows and 25 columns. There are two columns in this spreadsheet I want to make use of and they are item number and bin location. The only problem is the item numbers in column B are duplicated in throughout the 10k rows. The other column I want to make use of is bin location which are also duplicated.
I want to find formula (maybe, index and match) to travel down the item number column and every excel reads my lookup value it travel across the spreadsheet and returns the bin location. See below result I am looking for, and thank you for reading my post.
Look up number (I would enter Item number here): I324789087-187
Bin# (populates)
CDFGV
VDOPV
DFGGK
-Bluetubevision
I currently have a spreadsheet that contains roughly 10K rows and 25 columns. There are two columns in this spreadsheet I want to make use of and they are item number and bin location. The only problem is the item numbers in column B are duplicated in throughout the 10k rows. The other column I want to make use of is bin location which are also duplicated.
I want to find formula (maybe, index and match) to travel down the item number column and every excel reads my lookup value it travel across the spreadsheet and returns the bin location. See below result I am looking for, and thank you for reading my post.
Look up number (I would enter Item number here): I324789087-187
Bin# (populates)
CDFGV
VDOPV
DFGGK
-Bluetubevision
