I am creating inventory count sheet
I have all items on one sheet - and multiple tabs for different places where counts are done
so if I go to one of the tabs and enter vendor and item number I can use index and mach 2 criteria array formula to find the item name from the main data sheet
so now each item has two counting units option, (like case and smaller count unit) with associated $ amount
on my counting sheet I want only to pick one counting unit, how can I say - if I find the item - mach counting unit for this item to the price on the main tab

a b c d e f g
vendor item# name case $ for case bottle $ price for bottle

my problem is that I have large range of different counting units in column d as well as for column f
I might put them down to 10 -12 and have list to choose from for counting unit, but how to find the item (index and mach) and than based on counting unit choose colum e or g
and I dont want to have 2 unit count options, since I can see the problem were counts will be entered in the wrong column

thanks