Apr 23 2021 04:51 AM
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
Apr 23 2021 05:36 AM
@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)
Apr 23 2021 06:05 AM
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.
Apr 23 2021 06:21 AM
Solutiondon't worry figured it out.....