Posting the workbook

  • Thread starter Thread starter cadustin
  • Start date Start date
C

cadustin

How can I post the workbook I am in so someone can help me with IF, INDEX and
MATCH combination formula?
 
To find the last numerical value use:

=INDIRECT(ADDRESS(ROW(),MATCH(MAX($D7:$IV7),$D7:$IV7)+COLUMN()))

To find the last value, number or text use:
=INDEX(D7:IV7,COUNTA(D7:IV7))

If there are blanks in the row, the following returns the last column entry
number or text

HTH - click 'yes' if useful
Peter
 
Thank you John, I was able to post with the URL to my document.

If you would like to help,
Insurance Premiums for leaves.xls

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.
 
Hi Cadustin
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
Regards
John
cadustin said:
Thank you John, I was able to post with the URL to my document.

If you would like to help,
Insurance Premiums for leaves.xls

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 said:
Hi
You upload your file to a site like this one
http://wikisend.com/ or this one http://www.mediafire.com/ . They are
free.
then you post the URL here so people can download your file.
HTH
John


.
 
Back
Top