+ Reply to Thread
Results 1 to 2 of 2

Fixing a specific cell and copying over

  1. #1
    Registered User
    Join Date
    10-25-2010
    Location
    cardiff wales
    MS-Off Ver
    Excel 2007
    Posts
    29

    Fixing a specific cell and copying over

    hi guys

    please take a look at the formula I have below

    =IFERROR(IF(LOOKUP(2,1/SEARCH($AG$4:$AG$15,$X21)),"T"),"O")

    the part of the formula I need looked at is the ,$X21)) is there a quick way I can copy this formula down so it goes from x21 to x22 and so on until it gets to x5000 then add $x$21 so the cell is locked.

    I have tried to put $x$21 the copy down however the cell number doesn't change

    thanks for your help

    Simon

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Fixing a specific cell and copying over

    =iferror(if(lookup(2,1/search($ag$4:$ag$15,indirect("$x"&rows($a1:a$1)+20))),"t"),"o")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying a Sheet with name of specific cell value
    By Axmed.cm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2015, 07:29 AM
  2. [SOLVED] Copying from one sheet to another if there is a value in a specific cell.
    By rdelosh74 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-01-2014, 09:38 AM
  3. [SOLVED] Copying Values of a Cell After a Specific Character
    By financeanalyst in forum Excel General
    Replies: 7
    Last Post: 04-02-2014, 04:54 PM
  4. Replies: 9
    Last Post: 12-30-2013, 11:35 AM
  5. [SOLVED] Copying a specific Row from another sheet depending on a cell value
    By OAKLEY in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-19-2013, 03:52 AM
  6. Copying row from one worksheet to another if a specific cell matches
    By Indy Amy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2013, 04:11 PM
  7. Fixing a value at a specific point on axis
    By lumo1985 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-19-2008, 07:29 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1