Thread: FORMAT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NBVC[_11_] NBVC[_11_] is offline
external usenet poster
 
Posts: 1
Default FORMAT


Try something like:


Code:
--------------------
=INDEX('Sheet2'!$C$2:$C$25,MATCH(1,INDEX(('Sheet2' !$A$2:$A$25=A1)*('Sheet2'!$B$2:$B$25=B1),0),0)-3)
--------------------


where Sheet2!A2:C25 contains your table and A1 on current sheet
contains 2009 and B1 contains 2...


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109382