In the attached spreadheet I can find an Item by either the pull down tab or by entering it in the a2 cell, what I have is multiple items in the same location so I must compare the Item # and Location and then have this item line appear. When I enter the Loc #, I always end up at the 1st Item in the numeric-alpha sequence. How do get around this?
Bookmarks