XLS file for lookup

[PiffPaff]

Dear Experts,

again I have a question.
I have a bigger xls file which I want to use as a lookup.
I tried everything I could think of, but still it's not working

A is the inputparamter and B should be "transformed" by the xls lookup.
I tried the following, but how can I get the xls file instead of the '????'

B=A FUNCTION OF(B,A)
B= WITH LOOKUP (
A,
????)

Thanks a lot!!!
Tobi

[Administrator]

Use "GET XLS LOOKUPS" to get the xy pairs of values (and call this parameter "LOOKUP FROM EXCEL F").

Now to use it,

b = LOOKUP FROM EXCEL F ( a )

[PiffPaff]

actually the EASIEST way

Thanks a lot!!!!

Tobi