Actually (1) is a way we tracj the member name.in bracket mostly it is of type14011, 13041,. I used "*"& string to lookup..

I m not getting the way to return received date from sheet 2...
I need is lookup with string and return the received date.