Hey Guys,
Only new to the excel world but trying to dive straight in. I have an issue. Pretty much I have received some lab results for specific samples which I have an expected result that should be returned. I have built a reference table with all the expected min and max range and specific name of said samples. I need to be able to look up the correct sample in my refence table and check if it's within the min and max range and give a pass or fail. I have done a IFS formula, but it was a whole A4 sheet long and thats just clunky and impractical. My database will be thousands and thousands of returned results and I can't afford to have it slow down. So I used a vlookup formula which I managed to get it to work very well. But more research it looks like that may slow down my workbook aswell. So I changed it to an Index/match formula. But it's not working for all the samples and I can't see a problem with it...
So my two questions are:
1: What is wrong with my formula?
2: Is my formula the most efficient and will ensure my spreadsheet doesn't slow down to a crawl?
Thanks in Advance!!!
Only new to the excel world but trying to dive straight in. I have an issue. Pretty much I have received some lab results for specific samples which I have an expected result that should be returned. I have built a reference table with all the expected min and max range and specific name of said samples. I need to be able to look up the correct sample in my refence table and check if it's within the min and max range and give a pass or fail. I have done a IFS formula, but it was a whole A4 sheet long and thats just clunky and impractical. My database will be thousands and thousands of returned results and I can't afford to have it slow down. So I used a vlookup formula which I managed to get it to work very well. But more research it looks like that may slow down my workbook aswell. So I changed it to an Index/match formula. But it's not working for all the samples and I can't see a problem with it...
So my two questions are:
1: What is wrong with my formula?
2: Is my formula the most efficient and will ensure my spreadsheet doesn't slow down to a crawl?
Thanks in Advance!!!