Even if you’re an experienced Excel user, you may not know this handy trick for automating column number references in the VLOOKUP formula. We’ll also cover holding the other range references constant by using the F4 key on your keyboard.
In case you missed it, check out the first post on VLOOKUP here, and/or read more about it in my previous blog here.
2 Comments
Mariana Trapnell
March 5, 2017Cait Vader: These are awesome!!!! 🙂
Mariana: Great to hear you’re enjoying them, Caitlin! Let me know if you have any suggestions for other topics to cover. 🙂
Mariana Trapnell
March 5, 2017Hey! I’m making a change to the blog to display only one Comments section and I’ll actually get notified when a comment is made. Unfortunately, that means previous comments made via Facebook will be removed. So that we don’t lose the information, I’ve copied them below. Thanks for joining in! Sharing knowledge is what this blog is all about, so it’s great when you take the time to share your knowledge too!
Leave A Response
You must be logged in to post a comment.