Discussion Re: What is the best formula to use? in Excel
https://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2224791#M93682
remove quotations in 10 as this is number, then it should workSat, 20 Mar 2021 12:12:05 GMTchahine2021-03-20T12:12:05ZWhat is the best formula to use?
https://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2195234#M92100
<P>Hi everyone,</P><P>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 next cell to the right of it.</P><P> </P><P>At first I tried an IF THEN statement but got nowhere. So then, I figured the easiest would be a VLOOKUP, but it isn't working either and returns an #N/A. So, I added a screenshot of an example of the formula I was trying. What am I doing wrong or is there an easier way to do this?</P><P> </P><P>The other thing is that there are spaces in between each row (that are not shown below) in my spreadsheet because the rows change in the data I'm pulling. What may have been in B3 today may be in B7 tomorrow. That is why I'm am needing to figure this out.</P><P> </P><P>The formula should be saying 21, but it is saying #N/A</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="catherine9910_1-1615275556247.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/261891i8A2DBD84BC5338CE/image-size/medium?v=v2&px=400" role="button" title="catherine9910_1-1615275556247.png" alt="catherine9910_1-1615275556247.png" /></span></P><P> </P><P> </P>Tue, 09 Mar 2021 07:41:29 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2195234#M92100catherine99102021-03-09T07:41:29ZRe: What is the best formula to use?
https://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2195322#M92104
<P><LI-USER uid="888027"></LI-USER> 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.</P><P> </P><P>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.</P>Tue, 09 Mar 2021 08:34:11 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2195322#M92104Riny_van_Eekelen2021-03-09T08:34:11ZRe: What is the best formula to use?
https://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2224482#M93652
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.Sat, 20 Mar 2021 06:53:56 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2224482#M93652catherine99102021-03-20T06:53:56ZRe: What is the best formula to use?
https://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2224791#M93682
remove quotations in 10 as this is number, then it should workSat, 20 Mar 2021 12:12:05 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-best-formula-to-use/m-p/2224791#M93682chahine2021-03-20T12:12:05Z