I am attempting to create a menu database for our restaurant. I want to
return the name of a supplier when I choose a specific menu item so that in
my cost column the correct price comes across. However sometimes we may
source the same item from two or more suppliers. I am not sure how to write a
formulat that states lookup this menu item and if the item chosen has two or
more suppliers then choose this supplier and provide the price per kilo/litre
etc (based on the chosen supplier). Does that makes sense? Any help would be
gratefully appreciated.