Dear ashish,
My question is
" I want to lookup multiple cell values in column2 basing a condition in
Column1 of Sheet1 and paste all the (for example 10 cells) cell values in
sheet2 in one after another rows"

In other words the following example may explain


Sheet 1 (The existing data) sheet 2 (What i am looking for)
col 1 col2 col1 col2
a 1 a 1
b 2 3

a 3 4
a 4 5
a 5

and the "A" in col1 of sheet2 will be changing frequently. Basing on the
condition "A" of col1 of sheet 2 the formula should copy all the related
values of col2 of sheet1 and paste them in col2 of sheet 2.

Hope i explained well.

"Ashish Mathur" wrote:

Dear Vijay,

Could you kindly be more descriptive in your question. Also, please paste
the data in the question so that the question is clear.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

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