Forum Discussion
Sponsority
Jan 03, 2023Copper Contributor
Help Requested--What Function to Use?
Please tell me the simplest Function to achieve the following: I'm creating a spreadsheet in which I'm trying to minimize the amount of user input. In this case, a user enters his or name, and a...
mtarler
Jan 03, 2023Silver Contributor
You want to use a LOOKUP function. I recommend the newest called XLOOKUP, which performs slightly better and has more versatility, but VLOOKUP (or HLOOKUP if organized in rows instead of columns) should work if you don't have a newer version of Excel
Sponsority
Jan 03, 2023Copper Contributor
Thank you so much. Struggled a bit copying the formula in the destination cells. Eventually realized I needed absolute cell references. (Examples are single row illustrations and don't mention this aspect.)
So glad I had this problem. More glad you helped. I realize I've only scratched the surface of Excel. Inspires me to learn more.
Gratefully, Chris
- mtarlerJan 03, 2023Silver Contributoryou're welcome and glad I could help steer you in the right direction.