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!
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!
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!
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.
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
Thanks kuschem, this works! Shame on me for not thinking about this
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]]".
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks