SOLVED

Excel Error #N/A

Occasional Contributor

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 the customers info on sheet 2,  sometimes it even works on the second line but not any further.  with a little green corner 

4 Replies

@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)

 

@Sandra_Ludick 

 

If it is at all possible.  I would like to mail you my excel sheet then I can explain to you what is happening.  It seems that 3 of the cells has some sort of value in that I can't get rid of.  Thank you very much for your reply.  Much appreciated.

@Sandra_Ludick Have sent you a DM

best response confirmed by Sandra_Ludick (Occasional Contributor)
Solution

don't worry figured it out.....