Automatic VLOOKUP Column References

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, 2017

    Cait 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, 2017

    Hey! 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