I've built an excel spreadsheet for helping me with an online golf game. Essentially its for calculating variables related to wind speed and direction, shot distance... among other things. My question is related to putting.
Variables: Putter Strength(which changes based on putt distance), Distance, elevation (uphill/downhill), Green Speed (fast, very fast, etc).
I'm trying to solve by having a table of variables with a look up on Green Speed and putter strength, returning the value at the intersection of these two variables.
I started with XLookup, but I think because I have multiple(2) lookups (Green Speed/Putter Strength) is doesn't work I could be wrong. Not sure if one of the Match functions will work here.
Any help is greatly appreciated.
Darrin HebertOP
@Reply 4 years ago
Kevin Robertson
@Reply 4 years ago
Try this formula changing the cell references for your sheet:
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.