GTA

All Springer/NP/PCP Air Gun Discussion General => Back Room => Topic started by: Crusher75060 on November 28, 2013, 12:56:44 PM

Title: A little spreadshee help
Post by: Crusher75060 on November 28, 2013, 12:56:44 PM

I'm trying to add a drop down list to my spreadsheet. I've got that part working by using "data validation". So you can pick from the list and get the proper Pellet name. However, if I can explain this without the sheet in front of you, I have this in sheet 2:
JSB Kings 25.39
H&N Baracuda 31.04
H&N Hollow Point 26.23
H&N Hunter Extreme 28.4
Predator Polymag 26

The pellet names are in the first column and the weights are in the next. I have the dropdown in lets say b2 on the main sheet. I want to be able to select the dropdown in b2 and get the name, but then I want c2 to lookup or vlookup or whatever the command is, see the name selected and automatically insert the corresponding pellet weight in the c2. I only use about 5 different pellets and have them listed, but I want the sheet to autofill the "grain" in c2 for me.
I think vlookup is the way to go since it will look up left column and then report column you designate from sheet2, but I can't seem to get the syntax correct. Could someone get me on the right track here? Maybe there is another way of doing it but I am not so well versed in Excel that I can figure it out. Any help would be appreciated.

Crusher
Title: Re: A little spreadshee help
Post by: EJB on November 28, 2013, 01:00:07 PM

I'm trying to add a drop down list to my spreadsheet. I've got that part working by using "data validation". So you can pick from the list and get the proper Pellet name. However, if I can explain this without the sheet in front of you, I have this in sheet 2:
JSB Kings 25.39
H&N Baracuda 31.04
H&N Hollow Point 26.23
H&N Hunter Extreme 28.4
Predator Polymag 26

The pellet names are in the first column and the weights are in the next. I have the dropdown in lets say b2 on the main sheet. I want to be able to select the dropdown in b2 and get the name, but then I want c2 to lookup or vlookup or whatever the command is, see the name selected and automatically insert the corresponding pellet weight in the c2. I only use about 5 different pellets and have them listed, but I want the sheet to autofill the "grain" in c2 for me.
I think vlookup is the way to go since it will look up left column and then report column you designate from sheet2, but I can't seem to get the syntax correct. Could someone get me on the right track here? Maybe there is another way of doing it but I am not so well versed in Excel that I can figure it out. Any help would be appreciated.

Crusher
I have several different spread sheets that I could send you and I could modify them to your liking.
Title: Re: A little spreadshee help
Post by: Bent on November 29, 2013, 06:15:55 AM

I'm trying to add a drop down list to my spreadsheet. I've got that part working by using "data validation". So you can pick from the list and get the proper Pellet name. However, if I can explain this without the sheet in front of you, I have this in sheet 2:
JSB Kings 25.39
H&N Baracuda 31.04
H&N Hollow Point 26.23
H&N Hunter Extreme 28.4
Predator Polymag 26

The pellet names are in the first column and the weights are in the next. I have the dropdown in lets say b2 on the main sheet. I want to be able to select the dropdown in b2 and get the name, but then I want c2 to lookup or vlookup or whatever the command is, see the name selected and automatically insert the corresponding pellet weight in the c2. I only use about 5 different pellets and have them listed, but I want the sheet to autofill the "grain" in c2 for me.
I think vlookup is the way to go since it will look up left column and then report column you designate from sheet2, but I can't seem to get the syntax correct. Could someone get me on the right track here? Maybe there is another way of doing it but I am not so well versed in Excel that I can figure it out. Any help would be appreciated.

Crusher

Here's how.. Lopslag is the same as Vlookup in english.... Test is the name of the area of the spreadsheet to "lookup"
PS. The spreadsheet is a HFT calculator...
Title: Re: A little spreadshee help
Post by: Bent on December 03, 2013, 07:21:06 AM
Did you make it work?