+ Reply to Thread
Results 1 to 7 of 7

Exchange rarge repeating formulas with names

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Bobruisk
    MS-Off Ver
    Excel 2013
    Posts
    11

    Exchange rarge repeating formulas with names

    Hello all,

    is there any way to replace repeating formulas with alias´?

    e.g. repeating index-match with some short text like "lookup#1"?

    Thanks!

  2. #2
    Registered User
    Join Date
    06-13-2018
    Location
    india
    MS-Off Ver
    2010;2007
    Posts
    54

    Re: Exchange rarge repeating formulas with names

    Hi!
    can you please be more specific or attach a sample workbook having 10-15 rows of data and covering all possibilities with results expected!

  3. #3
    Registered User
    Join Date
    07-11-2013
    Location
    Bobruisk
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Exchange rarge repeating formulas with names

    Hello kuschem,

    this is really simple like this:

    instead of having (this is just an example): = VLOOKUP("Something", A2:B16, 2, FALSE)& " " &VLOOKUP("Somewhere", A2:B16, 2, FALSE)

    I´d like to be able replace it with: = vlookup#1 & " " & vlookup#2

    THe point is, I have long parts of formula repeating plenty of times. Using names like above would make creating and reading this formula much easier.

  4. #4
    Registered User
    Join Date
    06-13-2018
    Location
    india
    MS-Off Ver
    2010;2007
    Posts
    54

    Re: Exchange rarge repeating formulas with names

    go to formula ---> name manager---->create new name (give some without spaces as vlookup_1)
    then copy paste your formula in dialogue box hit enter

    when you want to use the same then go to cell type = and hit F3 it will give you the list of these names


    if this helps the click add reputation at the bottom left corner of this post

  5. #5
    Registered User
    Join Date
    07-11-2013
    Location
    Bobruisk
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Exchange rarge repeating formulas with names

    Thanks kuschem, this works! Shame on me for not thinking about this

  6. #6
    Registered User
    Join Date
    07-11-2013
    Location
    Bobruisk
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Exchange rarge repeating formulas with names

    Hey kuschem,

    do you know how I can use structured references in named formulas?

    Here is the actual formula I´m trying to save under a name:
    =INDEX(Yclass_DB[[Jan-18]:[Dec-18]],MATCH([@[Short Name]]&"actuals",Yclass_DB[Short name]&Yclass_DB[Type],0),MATCH(Cost_Avoid_DB[[#Headers],[Jan-18]],Yclass_DB[[#Headers],[Jan-18]:[Dec-18]],0))

    Name manager spits out an error when I am trying to save it. It marks this part of the formula "MATCH([@[Short Name]]".

  7. #7
    Registered User
    Join Date
    06-13-2018
    Location
    india
    MS-Off Ver
    2010;2007
    Posts
    54

    Re: Exchange rarge repeating formulas with names

    may be its a part of table so its not accepting the same , you can try to take references instead of structured references as $A$2:$A$25 or so

+ 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. Replies: 7
    Last Post: 12-05-2016, 10:23 AM
  2. Repeating Names
    By sambatey in forum Excel General
    Replies: 3
    Last Post: 10-19-2015, 02:16 PM
  3. pick a name out of list of 20 names without repeating names picked
    By gammoneer2b in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-06-2014, 10:14 AM
  4. How to List Only Non-repeating Names?
    By omaral in forum Excel General
    Replies: 4
    Last Post: 03-05-2014, 04:07 PM
  5. quantifying repeating names
    By Cashew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2012, 11:59 PM
  6. How to filter repeating Names
    By ctrl lady in forum Excel General
    Replies: 4
    Last Post: 08-18-2006, 05:57 AM
  7. List of repeating names
    By johnT in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-29-2005, 06: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1