Forum Discussion
Solved
Excel Error #N/A
I am doing a course in excel and is following the instructions to a T. But after as instuckted to put $ signs in the selector cell bar and drag it down. It gives me errors. I am trying to add t...
don't worry figured it out.....
Sandra_Ludick Not sure what you are trying to achieve, but when you put the dollar signs in the lookup range as well you will get a result. But it will be the same for all as rows as the lookup value (A7) is also fixed by the dollar signs.
=VLOOKUP($A$7,Customers!$A$2:$G$4,2,FALSE)