Listbox Type Mismatch when retrieving formula from cell

[impresxy]

Hi,

My Listbox shows error Type Mismatch when I try to retrieve value from the column where I have index match formula. Can you please help me how should I write the code to get this value shows on the listbox?

My code now :

Please Login or Register  to view this content.

[jindon]

What happen if you change it to

Please Login or Register  to view this content.

[impresxy]

Hi Jindon,

It returns correct value now. Thank you very much