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 when entering style code and item name the rate pickup automatically against value so please help me how this is possible.
1 Reply
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.
