Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Loungers

    I have this formula =VLOOKUP($B$18,'Personnel Input Sheet'!A5:L35,'Personnel Input Sheet'!D1,TRUE) that goes to DT01, the range stays the same in all of them, all that changes is the sheet reference. Is there a quick way to change it to =VLOOKUP($B$18,'Machine hours Input Sheet '!A5:FL35,'Machine hours Input Sheet '!D1,TRUE) with out having to either paste or reassign the range?

    I tried find and replace with view formula on, but that did not work - any other suggestions?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='verada' post='762095' date='26-Feb-09 21:53']I tried find and replace with view formula on, but that did not work - any other suggestions?[/quote]

    In what way did it not work? It works in my testing.

    Can you provide a more detailed explanation or the error message maybe. Or if possible a sample workbook.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Mike - not sure what I did differently, but has now worked.

    Thanks for your help

    Regards

    Dean

Posting Permissions

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