Chart look up

[Gabriel]

Hi my name is Gabriel

I'm wondering if some one can help me to code a function that will help
me look for some data using three values



I'm using an excel file as a capturing template for our staff and I
need to have this function done.

I have a chart in a separate excel file please see file attached that
will demostrate better what I have


On a separate file linked to the chart the user will type the month(s)
and year(s) and the number of person(s):



Month Year 11/2001



Staff # 3





What I need is an Excel function that will go and look for the value
that corresponds to those entries in this case will be 356 the
return value will be placed on a designated cell, and then will be used
to complete other computations. This action will be repeated as
entries are made and may go from one to 60 times and may be for
different months, years and number of person. I do have the chart
already created.



Some one has told me that this will be possible by using a double vi
look up, I don't have much idea of how to put this function together
and I'm wondering if someone can help me with that. I do use excel, and
I haven't been asked to do that type of search before.



I will appreciate your advice and help to solve this situation.

Gabriel


+----------------------------------------------------------------+
| Attachment filename: chartquestion1.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=350059|
+----------------------------------------------------------------+

 

[L. Howard Kittle]

Hi Gabriel,

With a slight change to your layout, this seems to do what you want.
Change as follows:

D6 = 2002
E6 = 2001
F6 = 2000


In G16 enter =INDEX(D7:F11,MATCH(E16,C7:C11,0),MATCH(D16,D6:F6,0))

Returns 365

HTH
Regards,
Howard