Forum Discussion
Solved
Help with either VLOOKUP or IF AND statements
Hello, I have a large table (~3000+) rows where we have multiple samples and each row has a different information. My goal in this is to create either a =IF AND statement or VLOOKUP stateme...
I switched to an AGGREGATE() formula. See attached file.
Hi
Neither VLOOKUP() nor IF() but INDEX() and MATCH().
Note: To make the formula work you have to remove some trailing spaces.
I have attached a file to describe what I previously posted
I switched to an AGGREGATE() formula. See attached file.
You are the absolute BEST!!!
You must be the guru on here! Thank you so much for your help. You will save me so much time in the future. Thanks again Detlef!!
You're welcome, Grant.