You're tackling some advanced stuff for a beginner.
Okay, first your question....
Where I wrote "Something Else" is where your second equation would go.
The equation you wrote however
will only return a True or a False depending on whether
returns an error or not. What exactly are you trying to do with your original formula?
Assuming you are attempting to retrieve from column B, whatever row you find in column A matching A7, then the formula should be written
So the whole thing would be;
ChemistB
Bookmarks