So, I work somewhere where we keep a spreadsheet for serial codes for consoles (mainly for warranty purposes). However the system is a bit inefficient so I'm trying to change it a bit.
We use references numbers for items and then the item name goes in the column after.
What I'm wanting is to be able to just type in the reference number and for
VLOOKUP to automatically return the item name.
Currently I have this:
This works fine but if I drag that formula to the next row it changes from
Essentially, what I'm asking is is there any way to make it so the lookup value can change but the range in which it looks through doesn't? At the moment the only solution I have is just repeating the table in which the master list of reference numbers is kept. As in, that master list is repeated from
G2 down to
This isn't really ideal for when new console variations would launch as I'd have to edit the entire thing again.
Thanks for any help, if need be, I can throw together a separate spreadsheet to share just to demonstrate what I mean.