Hi,

I'm not sure if you mean this with your AU02 etc codes in column E

=IF(H2="Critical",E2,"")

or this

=IF(H2="Critical","AU"& TEXT(ROW(E2),"00"),"")

Mike

"GireeshaJ" wrote:

i have list in the "H" Column, which has (Critical, major, minor).

A column has AU01 and so on...

i wanted to list all the A column values for critical.

ex: if H2, H12 and H 23 are selected with critical.
and in the result cell, it should display AU02,AU12 and AU23.

please give me solution as early as possible...

thanks a lot in advance...

regards
Gireesha