Hi,
I have been through a number of tutorials about using XLOOKUP, INDEX and MATCH but I can't get the syntax right, was hoping someone could help? Thanks
What I trying to do is: If the "Material" column is "Metal" match the number in the "Sold ID No" with the "Part No" column and display the value in the "Price" column in Sold Price
I have been through a number of tutorials about using XLOOKUP, INDEX and MATCH but I can't get the syntax right, was hoping someone could help? Thanks
What I trying to do is: If the "Material" column is "Metal" match the number in the "Sold ID No" with the "Part No" column and display the value in the "Price" column in Sold Price
Part No | Toy | Price | Material | Sold ID No | Sold Price | ||
10001 | Scateboard | $10 | Plastic | 10003 | If Material = "Metal" what is the Price | ||
10002 | Bike | $100 | Metal | 10002 | |||
10003 | Train | $120 | Plastic | 10001 | |||
10004 | Car | $50 | Metal | ||||
10005 | Airplane | $75 | Metal | ||||
10006 | Rocket | $60 | Plastic |