Prev: Vlookup with variable column reference
Next: If then between two dates
From: cadustin on 19 Mar 2010 15:33
How can I post the workbook I am in so someone can help me with IF, INDEX and
MATCH combination formula?
From: John on 19 Mar 2010 16:06
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
"cadustin" <cadustin(a)discussions.microsoft.com> wrote in message
news:134E048A-1067-403F-B092-1D23218B05DE(a)microsoft.com...
> How can I post the workbook I am in so someone can help me with IF, INDEX and
> MATCH combination formula?

From: Billy Liddel on 19 Mar 2010 16:21
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
=LOOKUP(2,1/(B6:IV6<>""),B6:IV6)
"cadustin" wrote:

> How can I post the workbook I am in so someone can help me with IF, INDEX and
> MATCH combination formula?
From: cadustin on 19 Mar 2010 17:11
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:

> 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
> "cadustin" <cadustin(a)discussions.microsoft.com> wrote in message
> news:134E048A-1067-403F-B092-1D23218B05DE(a)microsoft.com...
> > How can I post the workbook I am in so someone can help me with IF, INDEX and
> > MATCH combination formula?
>
> .
>
From: Herbert Seidenberg on 19 Mar 2010 22:49
Excel 2007 Tables
A modern version:
http://www.mediafire.com/file/idxcz0ymg2m/03_19_10c.xlsx

 |  Next  |  Last
Pages: 1 2
Prev: Vlookup with variable column reference
Next: If then between two dates