I need to be able to automatically update the cells in column c and d based on the value entered in column b. I have a named range "key" for the possible entries in column c and d and have been using these forumulas:
=IF(B2="","",VLOOKUP(B2,KEY,2,FALSE)) 'for column c' =IF(B2="","",VLOOKUP(B2,KEY,3,FALSE)) 'for column d'
basically, I have a lot of data entry and don't want to have to copy and paste the formulas down every time I do data entry. Is there a way to have these formulas always apply to colums c and d without copy and pasting them so often? I guess I'm looking for a way to conditionally format these columns, but use the formula instead of a format. Thanks again for your time.
Answer from Richard Rost:
If you're using Excel 2007 or 2010, you can set this up as a TABLE and the formula will be copied down automatically each time you add a row. If you're using an older version of Excel, I'm afraid there is no easy way to automatically do so.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
