View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default Help with a Lookup, I think

Dear MAX AND MUDDAN

yES i ACTUALLY WORKED IT.

THANKS FOR YOUR HELP

"Max" wrote:

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
---