Forum Discussion
XLOOKUP using 3 unique criteria
I have almost completed my pet project, but I have one final piece that I cannot figure out. First off, I work in insurance where I audit incoming (uploaded) spreadsheets from insurance reps. Th...
You can use FILTER() function easily to meet 3 criteria. Please share a sample file and show your input and desired output. You may attach the file in post or via GoogleDrive, OneDrive, Dropbox etc.
Thank you for your response. I will share a sample file when I get home tonight. This will be the same sample file I used when I posted this issue in a different Excel forum and it produced a few weird errors (because I rebuilt it rather quickly and didn't worry about perfection) that do not affect anything important and I will declare those issues when I post the sample file.