Apr 1, 2010 at 01:35 AM
Posts1864Registration dateSunday June 14, 2009StatusContributorLast seenAugust 7, 2021
Apr 1, 2010 at 10:15 PM
Im very basic excel user, Im trying to Search a Database of 6500+ entrys, Its a basic search that i cant seem to work correctly.
Basically Each row is a Separate entry per item, some items have 3 rows some have 5+ rows
A= item number b= item type d-f= useless info that cannot be deleted H=part number
NOw ultimately I want to search for Item type 101, inside Item number 202 and come up with a correct part number
So first i need to Search for Item number, with a second search for item type to give me Part number, it sounds so easy in my head, but i cant seem to find the correct formula.
example of my work is, I have a type of paint, in that paint is different colors, each color has a separate bar-code label with mixing instructions, I need to create an easier search method then Ctrl-f.