Lookup feature

[hesomist]

Okay, this is my first post on the site, and I hardly know anything about the advanced features of Excel. But I'm working on a golf handicap tracker for myself, and need some help.

I have a sheet that includes a list of golf courses that I have played, along with that course's name, slope, and rating (along with some other general course information). The information for each course is on its own row.

On another sheet (the handicap tracker), I currently have it setup where I have to enter the course name, slope, and rating (along with my score) to calculate my handicap. Therefore, I have to click to the course sheet to gather the course information, and then I must click back to the handicap sheet and type it in manually.

Is there a way to set it up (either with regular formulas or with code) to enter a course name on the handicap sheet and have that course's information be automatically pulled from the courses sheet and put onto the handicap sheet?

 

[Puuuuma]

It sounds like a vlookup would do what you want, although it depends on if you have multiple occurances of the same course.

Vlookup(the value you want to match - the cell with the course name, the table you are pulling the information from (the golf course title has to be the first column in this selection), the column number in the table that you want pulled back into the given cell, True (which pulls the first instance that the course title is close) or False (an exact match to the title - I recomend using this one)

 

[iliace]

Excel Workbook
	A	B	C	D	E	F	G
1	Course Name	Slope	Rating
2	abc	0.5	good			Lookup	Lookup
3	def	0.75	bad		def	0.75	bad
4	geh	1.2	ok
Sheet1

 

[hesomist]

Thanks!! I'll see if I can make that work.