View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] ciojr@yahoo.com is offline
external usenet poster
 
Posts: 2
Default nested vlookup needs to remove #name?

I have the following
=IF(VLOOKUP(I14,'ISSUES (2)'!$B:$M,12,FALSE)="M",
20,IF(VLOOKUP(I14,'ISSUES (2)'!$B:$M,12,FALSE)="H",
40,ifIF(VLOOKUP(I14,'ISSUES (2)'!$B:$M,12,FALSE)="L",12,0)))

if no match is found, i get #NAME?

how can i replace this with 0 if no match is found

Thanks in advance and happy easter.