Insert different values in a formula

  • Thread starter Thread starter Lore
  • Start date Start date
L

Lore

Hi!

I have a work sheet that is linked to a system that I cannot access.
To bring a value, the formula is the following:

=mxdb|quotes!dvn.last
that brings a result for the value or item "dvn"

If I want to change that value "dvn" for another with a different name, lets
say "pep", is there a way where I can write the new values in a column and
then the formula inserts the new value that I need? So the formula would
look like:

=mxdb|quotes!pep.last (so I get the "pep" result)

What I am doing now, is change the name in the formula for each cell that I
need to get the new result for the new item and that takes me forever and
that is not the way the work sheet is supposed to work.
So...to summarize:

I need the formula to bring or insert the new value that I input in a
different colum.
(in that column I'll just write down the new name and I will get the result
where the formula is).
I don't think that I can use any LOOKUP formula, since I cannot access the
data base directly and I cannot specify an array.

I need help with the formula, pleeeease!!!!

Thanks!

Lore D.
 
Maybe something like this, assuming your formula is in A1 and your new value
is in E1...

="mxdb|quotes!"&E1&".last"

Vaya con Dios,
Chuck, CABGx3
 
Thank you Chuck!!

It partially worked.
I tried in a work sheet that had the macros disabled.
When I wrote the formula that you gave me, it changed the word, but in the
cell it kept showing the formula and not a result. I thought that was
because the macros were disabled, so I tried on a work sheet that has the
macros.

The same result. In the cell it shows the formula and doesn't bring any
value (I can actually see the formula in the cell after I press enter).
Besides, excel brings up a windows that is suggesting to fix the formula.
It highlights some of the "".
I tried to delete some (and all). Didn't work.
Since is not bringing any value back, the other cells that depend on the
result of the cell we are working on, mark and error (or #VALUE! or some
error note).
There is still something that I need to do so it brings the information from
the source.....and I don't know what is it!!

Could you help me some more, please?

Thank you veeeery much!!
LoreD.
 
Try it first this way
=mxdb|quotes!pep.last
with the pep in place to make sure the path works...........then try

=mxdb|quotes!&E1&".last" this way it calls for remote data which is
unavailable to me.........maybe it will work for you this way...........

Vaya con Dios,
Chuck, CABGx3
 
Hola Chuck!

First I tried the formula with the "pep" in place. It worked.
Then I tried what you suggested and excel didn't like it either.
It opens a windows that says: "The formula that you entered contains an
error. Try the following..." (and gives me some options)
When is suggesting to fix the formula, it highlights the cell and row (E1).

I think that we are close....!
Do you have any other suggestion?

Thank you for all your help!!!
Vaya con Dios, tambien!

LoreD.

P.S. One more question: The quotation marks that you suggested the last
time go like this: =mxdb|quotes!&E1&".last" (before the "period" and after
"last").
 
If you put =mxdb|quotes!&E1&".last" in A1 and pep in E1, it should be the
same thing as when you put =mxdb|quotes!pep.last in A1........

I don't know what else to suggest, unless you want to send a copy of your
file to my home addy and I will take a look at it........

Vaya con Dios,
Chuck, CABGx3
 
Hi!
The first formula that you gave me (="mxdb|quotes!"&E1&".last") writes the
new value into the formula,and then the cell shows the formula with the new
value written in it, but doesn't bring the result from the source that we
cannot access.
I checked the cell format and it is "general"
I also tried it in another cell and had the same result.
Maybe the system that I am trying to access doesn't allow "custom made"
formulas!
I will check if I am allowed to send a copy of the file for you to take a
look at it.

Thank you for all your help and patience!!

Hasta luego!

LoreD.
 
Back
Top