Good evening

I need a formula to get item costs from a vender list. I have 2 tabs, in the first tab “worksheet”, the second tab is “venders”, with the items and prices. On the worksheet tab I created a drop down list with the venders names in cell A3, and a second drop down list in cell B3 with the names of the items. when I select a vender and an item I want cell C4 to show the cost of that item from that vender.

this is the formula I tried to use

(=XLOOKUP(A3,venders!A3:A14,’work sheet’!B3,venders!B4:B14,venders!C4:C14), below is the result.

any help is appreciated.

​Good eveningI need a formula to get item costs from a vender list. I have 2 tabs, in the first tab “worksheet”, the second tab is “venders”, with the items and prices. On the worksheet tab I created a drop down list with the venders names in cell A3, and a second drop down list in cell B3 with the names of the items. when I select a vender and an item I want cell C4 to show the cost of that item from that vender.this is the formula I tried to use(=XLOOKUP(A3,venders!A3:A14,’work sheet’!B3,venders!B4:B14,venders!C4:C14), below is the result.any help is appreciated.      vender aitem#VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!    Read More

​