vlookup?

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have this formula =IF(P3>0,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
 
-----Original Message-----
Hi Scott
see your answer in Excel.worksheet.functions
Frank
P.S.: please don't multipost



.
Hi Frank. I guess I need a little help tracking the
Click to expand...
answer down in excel.worksheet.functions. Did my question
show up there also? Thanks.
 
Hi
a repost to your question
-----
try
=IF(P4>0,SUMIF('InvRevMarMutFds'!$B$1:$B$69,C4,'InvRevMarMutFds'!$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)
 
Back
Top