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

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Manos" wrote in message
...
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004

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

"Ken Wright" wrote:

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Manos" wrote in message
...
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004