=INDEX(A:A,MATCH(lookup_Date,B:B,0)
"namrataparswani" wrote in message news:...
Message-ID:
X-Mailer: http://www.umailcampaign.com, ip log:122.169.22.175
Newsgroups: microsoft.public.excel.worksheet.functions
NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 70.84.187.34
Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl!newspe.c om
Lines: 1
Xref: TK2MSFTNGP01.phx.gbl
microsoft.public.excel.worksheet.functions:473979