LinkBack URL
About LinkBacks
this worked for me.... thanks.
=IF(ISNA(MATCH(Z2,$W$2:$W$10,0)),1,INDEX($W$2:$X$10,MATCH(Z2,$W$2:$W$10,0),2))
so is it impossible to have more than 8 statements in an if function?
this worked for me.... thanks.=IF(ISNA(MATCH(Z2,$W$2:$W$10,0)),1,INDEX($W$2:$X$10,MATCH(Z2,$W$2:$W$10,0),2))
so is it impossible to have more than 8 statements in an if function?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks