Forum Discussion
Formula help
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 create...
Hi DerekK1590
Your setup isn't top clear to me so this might not be exactly what you want. In attached file you'll see I formatted data as Table (in sheet 'Venders'). I would recommend you to adopt it as Tables bring a lot of benefits and make formulas much more easy to construct and to read
With the Table with the Vendors, Items & Prices, named 'VendersCost':
in C4:
=IF( COUNTA( A3:B3 ) = 2,
FILTER( VendersCost[price],
( VendersCost[vender] = A3 ) * ( VendersCost[item] = B3 ),
"No match"
),
""
)
You're welcome DerekK1590 & thanks for providing feedback