View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zia Butt Zia Butt is offline
external usenet poster
 
Posts: 1
Default FIND A VALUE FROM CROSPONDING COLUM AND MULTIPLE CROSSPENDING ROW

S.NO Name "Pay Date/Paid Date"
A B
1 Zia 01/01/2010
2 03/01/2010
3 amir 12/12/2009
4 01/01/2010

Find the value for Zia (A1) from crossponding column B but row no 2 (B2)
whch is " 03/01/2010"