How to retrieve values from excel

Hi

Can i retrieve a value from excel?

Something like:
set user variable
Name: myvar value: =VLOOKUP(123,Sheet1!A1:B10,2)

Many thanks

Yes, here's an extract from the manual, chapter "Triggered Betting - Reference - Variables - Excel-Bound Variables":

Syntax

cell_[sheet_name]_[cell_address]

The [sheet_name] and [cell_address] are the address of the cell a value is stored in. The sheet must exist in the Excel file MF Pro is connected to, and the cell's address must comply with Excel notation. For example:

- cell_sheet1_B3

- cell_mysheet_A4

Thanks for your quick reply,

but you can see from my example i want a value from a formula. I dont have a cell with a value. It's the return of vlookup that i'm interested.

Many thanks

But you can insert this formula (or any formula for that matter) into a specific cell in your sheet and then read the value of that cell from inside MF Pro.

I expressed myself badly.

From my example 123 is a variable.

I want something like a function.

So, i want to send a var to a cell with vlookup and catch the return value.

You can try the Custom Cells then: it is possible to feed any variable or trigger expression to a predefined cell in Excel, and then read it back using a trigger.
Plenty of examples in the manual too, section "Excel Interface - Custom Cells".

I had read that part of the manual but didnt understand that way.

Feeling silly now.

Many thanks.

Don't be, I'm here to shed light on all the obscurities of the manual.

How to retrieve values from excel

Hello Guest