Forum Discussion
Need Formula for Excel?
Dear All, Please help me below Style Code Item Price GPW-930 Shirt $ 600.00 GPW-930 Trouser $ 200.00 GPW-930 Dupatta $ 100.00 I want to use a formula...
Let's say that your list of style codes, item names and prices is in A2:C100 on a sheet named Item List.
On another sheet, you enter a style code in A2 and an item name in B2.
Enter the following formula in C2:
=IFERROR(INDEX('Item List'!$C$2:$C$100, MATCH(1, ('Item List'!$A$2:$A$100=A2)*('Item List'!$B$2:$B$100=B2), 0)), "")
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
The formula can be filled down if required.