Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MM
 
Posts: n/a
Default how do I add new rows when doing vlookup function?


  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

Just add em

Ask an incomplete question-get an incomplete answer.


--
Don Guillett
SalesAid Software

"MM" wrote in message
...



  #3   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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

HTH,
Bernie
MS Excel MVP

"MM" wrote in message
...



  #4   Report Post  
Brad
 
Posts: n/a
Default

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?


"Bernie Deitrick" wrote:

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

HTH,
Bernie
MS Excel MVP

"MM" wrote in message
...




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
carrying a hyper link when using the vlookup function mike Excel Worksheet Functions 1 November 19th 04 03:49 AM
carrying a hyper link when using the vlookup function mike Excel Worksheet Functions 2 November 18th 04 04:22 PM
Regarding IF function or vLOOKUP function wuwu Excel Worksheet Functions 2 November 13th 04 01:38 PM
Use of Exact(or other) function for alternate rows? yusee_ygs Excel Worksheet Functions 2 November 3rd 04 08:44 PM
vlookup and IF function cambridge Excel Worksheet Functions 5 October 28th 04 08:29 PM


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"