+ Reply to Thread
Results 1 to 6 of 6

Change part of a VLOOKUP formula across mulitple cells and worksheets

  1. 11-20-2014, 05:35 PM #1
    nilelator
    nilelator is offline
    Registered User
    Join Date
    12-13-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2010
    Posts
    39

    Change part of a VLOOKUP formula across mulitple cells and worksheets

    Below is the formula that I am using in multiple Tables, and multiple worksheets they all go back to the same place "Price List" the problem that I have is the price list has changed. I have to copy and paste the new "Price list" sheet from the new workbook to my old work book that I have expanded from the way the new one is done (which is done by others) and the old formula refers to column D8:k12156 and I need to change it to C8:K18156 I have tried to change the price list but all the formulas auto change with it.

    any suggestions?

    old formula "=VLOOKUP("AAAC0012012",'Price List'!$D$8:$K$12156,4,FALSE)"
    New formula " =VLOOKUP("AAAC0058012",'Price List'!$C$8:$K$18156,4,FALSE) "
    Reply With QuoteRegister To Reply
  2. 11-20-2014, 06:05 PM #2
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Change part of a VLOOKUP formula across mulitple cells and worksheets

    Ctrl+H

    Find
    'Price List'!$D$8:$K$12156

    Replace With
    'Price List'!$C$8:$K$18156

    Replace All
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!
    Reply With QuoteRegister To Reply
  3. 11-20-2014, 06:12 PM #3
    nilelator
    nilelator is offline
    Registered User
    Join Date
    12-13-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Change part of a VLOOKUP formula across mulitple cells and worksheets

    you know I tried that first and it wouldn't work... then I tried it again after your post and it work... it's been a long day.
    thanks for your help
    Reply With QuoteRegister To Reply
  4. 11-20-2014, 06:19 PM #4
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Change part of a VLOOKUP formula across mulitple cells and worksheets

    No problem.

    Ctrl+H can be messy, especially if you accidentally select 2 cells, in which case it only works on two cells.

    Or worse, when you select one cell accidentally, and change it everywhere unintentionally.
    Reply With QuoteRegister To Reply
  5. 11-20-2014, 06:59 PM #5
    nilelator
    nilelator is offline
    Registered User
    Join Date
    12-13-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Change part of a VLOOKUP formula across mulitple cells and worksheets

    I figured out what I did wrong the first time I was copying and pasting to the find box and I was not going back to the original workbook first before I told it to find and replace
    Reply With QuoteRegister To Reply
  6. 11-20-2014, 07:15 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Change part of a VLOOKUP formula across mulitple cells and worksheets

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copying filtered rows from mulitple worksheets to one worksheet (BUT not all CELLS)
    By kano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2013, 04:38 AM
  2. Excel 2007 : Drag formula over cells and change a specific part of it
    By marianmix in forum Excel General
    Replies: 2
    Last Post: 03-20-2011, 03:13 PM
  3. Change part of a formula across many worksheets
    By HUMMINGBIRD2010 in forum Excel General
    Replies: 0
    Last Post: 01-18-2011, 09:15 AM
  4. Sum Cells in Mulitple Worksheets
    By dbroderick in forum Excel General
    Replies: 2
    Last Post: 11-19-2010, 02:44 PM
  5. mulitple worksheets vlookup
    By Max_power in forum Excel General
    Replies: 7
    Last Post: 03-21-2006, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1