Function for VLookup using values for two columns

**m.raby** · 07-30-2012, 09:23 AM

I am building a handicap calculator for golf, using pre-specified courses.

Attached is an example of the sheet. What I need assistance with is a VLOOKUP function. I am trying to make a function that will search for the course name (From Column B in Sheet "Handicap"), and then also do another search for the Tees played (From Column C in Sheet "Handicap"). I would like the function to be able to return the Slope and/or Course Rating from the Sheet "Courses" for the equivalent rows that it just searched for in the Table.

What would the VLOOKUP function look like for multiple lookups?

**m.raby** · 07-30-2012, 09:37 AM

Resolved myself

**Melvinrobb** · 07-30-2012, 09:47 AM

Here is my solution:

I added a "helper" column in your source table. The column simply combines the course with the Tee position.
The vlookup function then references both and is able to find the appropriate data.
NOTE: your listing of the course in the Handicap table was not EXACTLY the same as the listing in the Courses table. This is necessary for the vlookup to work properly.

Function for VLookup using values for two columns

LinkBack

Thread Tools

Rate This Thread

Display

Function for VLookup using values for two columns

Re: Function for VLookup using values for two columns

Re: Function for VLookup using values for two columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions