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...
There are couple of ways. You may try nested XLOOKUP() or FILTER() or INDEX/MATCH combinations.
=XLOOKUP(I4,$A$4:$A$7,XLOOKUP("price client " &K4,$C$3:$D$3,$C$4:$D$7,""))
=FILTER(FILTER($C$4:$D$7,$C$3:$D$3="price client "&K4,""),$A$4:$A$7=I4)
=INDEX($C$4:$D$7,MATCH(I4,$A$4:$A$7,0),MATCH("price client "&K4,$C$3:$D$3,0))
