Hello,
I must calculate a Listbox by the numbers of an other Listbox by the function "vlookup". I found many solutions with ListBox and vlookup, but any solution solve my problem.
For example ListBox1 has got 16 values. ListBox to must calculate. The Excel-function, which must stand in every box of the ListBox2 in ListBox2:
(G$8;$F$5:$H$7;3;0)(H$8;$F$5:$H$7;3;0)(I$8;$F$5:$H$7;3;0)
(G$9;$F$5:$H$7;3;0)(H$9;$F$5:$H$7;3;0)(I$9;$F$5:$H$7;3;0)
(G$10;$F$5:$H$7;3;0)(H$10;$F$5:$H$7;3;0)(I$10;$F$5:$H$7;3;0)
Please help
I must calculate a Listbox by the numbers of an other Listbox by the function "vlookup". I found many solutions with ListBox and vlookup, but any solution solve my problem.
For example ListBox1 has got 16 values. ListBox to must calculate. The Excel-function, which must stand in every box of the ListBox2 in ListBox2:
(G$8;$F$5:$H$7;3;0)(H$8;$F$5:$H$7;3;0)(I$8;$F$5:$H$7;3;0)
(G$9;$F$5:$H$7;3;0)(H$9;$F$5:$H$7;3;0)(I$9;$F$5:$H$7;3;0)
(G$10;$F$5:$H$7;3;0)(H$10;$F$5:$H$7;3;0)(I$10;$F$5:$H$7;3;0)
Please help
