From: John on 20 Mar 2010 11:09
Have a look at your form, this is the link; http://cjoint.com/?duqeuQ3A48
Your formula was good, just one parentheses at the wrong place.
Post back if you need more help
"cadustin" <cadustin(a)discussions.microsoft.com> wrote in message
> Thank you John, I was able to post with the URL to my document.
> If you would like to help,
> [URL=http://wikisend.com/download/522620/Insurance Premiums for
> leaves.xls]Insurance Premiums for leaves.xls[/URL]
> I am trying to get excel to put in the amount matching the 3 different
> criterias I have set up. My look up information is on Page 2 and my document
> is Page 1.
> I want excel to look at F2 and depending on what that says, look at my other
> two criterias and give me the corresponding amounts.
> "John" wrote:
>> You upload your file to a site like this one
>> http://wikisend.com/ or this one http://www.mediafire.com/ . They are
>> then you post the URL here so people can download your file.
>> "cadustin" <cadustin(a)discussions.microsoft.com> wrote in message
>> > How can I post the workbook I am in so someone can help me with IF, INDEX
>> > and
>> > MATCH combination formula?