I have this formula =IF(P30,VLOOKUP(C3,InvRevMarMutFds!
$B$1:$K$69,9,FALSE)/M3,"0")
This works great except that the C3 lookup criteria shows
up on more than one row. If the resulting answer of the
first match is zero, how can I have the formula look at
the next row in which the matching lookup criteria
appears, and has a resulting answer of 0.


Thanks for help. Scott

Hi Scott
see your answer in Excel.worksheet.functions
Frank
P.S.: please don't multipost

Scott wrote:
I have this formula =IF(P30,VLOOKUP(C3,InvRevMarMutFds!
$B$1:$K$69,9,FALSE)/M3,"0")
This works great except that the C3 lookup criteria shows
up on more than one row. If the resulting answer of the
first match is zero, how can I have the formula look at
the next row in which the matching lookup criteria
appears, and has a resulting answer of 0.


Thanks for help. Scott

-----Original Message-----
Hi Scott
see your answer in Excel.worksheet.functions
Frank
P.S.: please don't multipost

Scott wrote:
I have this formula =IF(P30,VLOOKUP
(C3,InvRevMarMutFds!
$B$1:$K$69,9,FALSE)/M3,"0")
This works great except that the C3 lookup criteria
shows
up on more than one row. If the resulting answer of the
first match is zero, how can I have the formula look at
the next row in which the matching lookup criteria
appears, and has a resulting answer of 0.


Thanks for help. Scott


.
Hi Frank. I guess I need a little help tracking the
answer down in excel.worksheet.functions. Did my question
show up there also? Thanks.

Hi
a repost to your question
-----
try
=IF(P40,SUMIF('InvRevMarMutFds'!$B$1:$B$69,C4,'In vRevMarMutFds'!$J$1:$
J$69)/M4,0)
format this cell as percentage (note: I also change "0%" to 0 as this
will return a value and not a string)

----


--
Regards
Frank Kabel
Frankfurt, Germany

scott wrote:
-----Original Message-----
Hi Scott
see your answer in Excel.worksheet.functions
Frank
P.S.: please don't multipost

Scott wrote:
I have this formula =IF(P30,VLOOKUP (C3,InvRevMarMutFds!
$B$1:$K$69,9,FALSE)/M3,"0")
This works great except that the C3 lookup criteria shows
up on more than one row. If the resulting answer of the
first match is zero, how can I have the formula look at
the next row in which the matching lookup criteria
appears, and has a resulting answer of 0.


Thanks for help. Scott


.
Hi Frank. I guess I need a little help tracking the
answer down in excel.worksheet.functions. Did my question
show up there also? Thanks.