View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Help with a Lookup, I think

What in this formula indicates that "Financials" is the worksheet that the
data has to be taken from?


Believe its meant like this
In Diary, in B24:
=INDEX(Financials!B:B,MATCH(H24,Financials!A:A,0)+ 2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---