Thread: €śUse of more then 7 nested if statement€ť
View Single Post
  #1   Report Post  
 
Posts: n/a
Default
Aladin Akyurek wrote...
=IF(ISNUMBER(MATCH(A2,$A$34:$A$40,0)),INDEX($C$34 :$C$40,MATCH(A2,$A$34:$A$40,0)),"")
....

Why INDEX(.,MATCH(.)) rather than VLOOKUP(A2,$A$34:$C$40,3,0)?

Reply With QuoteReply With Quote