Conversion lookup formula

[Manos]

Dear all,
Does anyone has work on formula with conversion look up?

=$L23*VLOOKUP($E23;conversion_lookup;3;FALSE)



can anyone help me discribing the above formula
multiply the value of cell L23 vertical looking the value of E23 ----


If it is possible to give me an example as well.

Thanks in advance
Manos

 

[Ken Wright]

Sorry but not quite sure what you want. If it's just an explanantion then the
formula you have posted will take the value in E23, and then look it up in the
leftmost column of the table conversion_lookup, and then if it finds an EXACT
match it will return the corresponding value from the 3rd column in the same row
in that table. It will then multiply that value with whatever is in L23.

The only thing that looks funny to me is the delimiter being a ; instead of a ,
but that may well just be your regional settings anyway.

 

[Manos]

Dear Ken
thank you very much for your explanation.

Yes insted of using comma the administrator has setup regional setting which
using the semicolon character.

Thanks again
Manos