how do I add new rows when doing vlookup function?

B

Bernie Deitrick

Perhaps, if you insert rows into your existing lookup range reference, your
formulas will update automatically.

HTH,
Bernie
MS Excel MVP
 
B

Brad

I believe that what MM is looking for I am running into as well. I have a
worksheets for each branch that pull info with a vlookup from a master sheet
for the entire company. If I decided I want to add a column to the sheet I
have to go into each branch sheet and update my formulas from that column on?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regarding Word Add in on Office 365 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Excel 2013 vlookup to different workbooks not working 3
Can I add a formula or function to Vlookup? 1
Help With VLOOKUP 2
Adding a comment in a footnote area 1
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0

Top