Forum Discussion
Formula to get prices from a catologue with a variable price colum
Hello, i'm currently creating an order table and I would like it to automatically retrieve prices from the catalog based on the reference (id ordered) and the customer. I was thinking of doin...
In L4:
=IFERROR(INDEX($C$4:$D$7, XMATCH(I4, $A$4:$A$7), XMATCH("price client "&K4, $C$3:$D$3)), "")
Fill down.
You'd have to adjust the ranges for your real worksheet.
