Formula from cell

[werko]

Hello!

It's there a formula to get the result from one cell "D2" "5x60" and then get the result on "C2" = 300...


Thanks!!

[oeldere]

VLookup

or

Index / match

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[werko]

Hi,

Richard,
Your formula gives me a "#VALUE!" error..

[JBeaucaire]

As far as I know, that can only be done consistently by adding a new function to your workbook, a User-Defined-Function (UDF). Here's one that works:

Please Login or Register  to view this content.

How to install the User Defined Function:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The function is installed and ready to use.
http://screencast.com/t/g2CdWdgNQit


Now, you use it like any other function. If your text string is in D2, the new function in C2 would simply be:

=RESOLVE(D2)

Here's a workbook with the function installed and several samples.

[Richard Buttrey]

Hi,

Does D2 contain
5x60
or
"5x60"

If the former then upload your workbook so that we can see the request in context.

[JBeaucaire]

See post #5 for a solution that should work for any basic math text string.

[werko]

Hi,

JBeacaire,

The cell D2 is 5x60, and when im trying your function method on my workbook i get the "can't find your project or library",
but when i use your workbook it works fine, now im coufused..

[JBeaucaire]

If you post your workbook with the UDF installed, I can check your work.

[Richard Buttrey]

The cell D2 is 5x60,.

Wuuld you upload your workbook please?

[werko]

here's the file

[oeldere]

If you put your code in a module instead of the sheet it will work.

See the attached file.

[Richard Buttrey]

here's the file

Hi,

The formula I gave you in post #3 works OK - see attached C2

[werko]

oeldere,

it's working good!

Preciate your help.... Thanks!!!

[werko]

Richard,

Thanks, your formula it's working too..

Now i have to decide wich one it's the best for my workbook..

[oeldere]

@werko

You got to thank JBeaucaire for the code.

I just added it in your workbook.

The UDF is a more robust one, so I would take that solution.

Although the solution of Richard Buttrey is also great (of course).

[JBeaucaire]

(hat tip to all)