Forum Discussion
Matching Values in formula with IF
I am a Jewellery Business owner and it is important for me to manage my inventory at the same time keeping a track of my rates as there are lots of variables that come in to play.... My problem i...
Parth25 VLOOKUP(), INDEX/MATCH(), FILTER(), XLOOKUP() all these function should work for your case. I would recommend to use XLOOKUP() function. See the attached file.
=IF(L2:L4/M2:M4<=0.065,XLOOKUP(K2:K4,Sheet2!A:A,Sheet2!B:B,"",0),"")
- Hey Harun24HR,
I tried your method but it is still not functioning properly- It must work. I think problem is in your IF() function logic. All the IF() result is not less than 0.065. Can you share a dummy workbook with fake data and explain where it is not functioning properly?
