Forum Discussion
Parth25
Aug 16, 2022Copper Contributor
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...
Harun24HR
Aug 16, 2022Bronze Contributor
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),"")
- Parth25Aug 16, 2022Copper ContributorHey Harun24HR,
I tried your method but it is still not functioning properly- Harun24HRAug 16, 2022Bronze ContributorIt 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?