if Cell A = [one of the item on sheetX Col A], Cell B = [Dropdown of items in Row of sheetX Row A]

Hi everyone,   I am trying to make a formula on the "Order" sheetname   There is another sheet called "Fruits", with details for The fruits and sellers. E.g. Apple can be sold by Alice or Bob P...