Once again thanks for all the previous help from these forum.
Here my problem is
i need to lookup up multiple values existing in a sheet and copy them in to
my quotation sheet. in other words i will have a customer reference number
in one column. basing on this reference number Excel should copy and paste
all the matching values in the next column to my quotation sheet (in row
after row).

Apologies if my example cannot give what exactly i am looking for.

Any speedy help would be really appreciable.