[Solved] A2 in VLOOKUP unchanged by copy down
Posted: Tue Apr 29, 2025 3:11 pm
Hello,
Hoping I can be relieved of my suffering.
And Im sure this has been answered many times before, but I cannot find the situation I require in the tutorials.
=VLOOKUP(A2; $Sheet1.A$2:B$60000; 2; 0)
I know this is wrong in format and syntax and probably everything, but Im so confused with googling, reading tutorials and watching you tube videos.
I have been attempting to make a parts list of my own Lego by entering in the part number and have the next cell auto filling with a description from a second sheet which has a large Lego parts list.
The A2 (cell to find the search data) in my example is not increasing in value to reflect the correct cell it is supposed to be searching from, when I drag the formula cells down.
Im not sure when and where to use the $ sign.
I have attached the file so that you can see what I mean.
Surely this is a simple formula and Ive only mucked up the wording/syntax.
Regards
Hoping I can be relieved of my suffering.
And Im sure this has been answered many times before, but I cannot find the situation I require in the tutorials.
=VLOOKUP(A2; $Sheet1.A$2:B$60000; 2; 0)
I know this is wrong in format and syntax and probably everything, but Im so confused with googling, reading tutorials and watching you tube videos.
I have been attempting to make a parts list of my own Lego by entering in the part number and have the next cell auto filling with a description from a second sheet which has a large Lego parts list.
The A2 (cell to find the search data) in my example is not increasing in value to reflect the correct cell it is supposed to be searching from, when I drag the formula cells down.
Im not sure when and where to use the $ sign.
I have attached the file so that you can see what I mean.
Surely this is a simple formula and Ive only mucked up the wording/syntax.
Regards
Edit: Changed subject, was VLOOKUP Make your post understandable by others -- MrProgrammer, forum moderator |