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.