Forum Discussion
What is the best formula to use?
Hi everyone, I have a project for work that I need help with. I have a macro pulling data from an external database, and I need to find a formula that will say if column a = blank, then return the n...
catherine9910 Assuming that the 10 in column B is number. If so, remover the quotation marks around the 10 in your formula, as it tries to match a text with a number and can't. Hence, #N/A.
Even better to replace the "10" in your formula with a reference to F3 and make the reference to the lookup range absolute, i.e. by putting $ signs in front of each column and row reference. Or create a named range or structured table of your data. Sorry, for offering all the different options, but there are many way to tackle things in Excel.
No, I like that you have given me multiple options to try that way I can find the best one for my project. Thank you.