Thread: vlookup?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 14
Default vlookup?

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