LinkBack URL
About LinkBacks
=(IF(ISERR(VLOOKUP(C2,'New Held Batches Sheet'!$C$5:$D$5,2,0),,1)+IF(ISERR(VLOOKUP(C2,'New Held Batches Sheet'!$C$8:$D$22,2,0),,2)+ and so on)=1 or 2
why not =VLOOKUP(C2,'New Held Batches Sheet'!$C$5:$D$35,2,0)?
=(IF(ISERR(VLOOKUP(C2,'New Held Batches Sheet'!$C$5:$D$5,2,0),,1)+IF(ISERR(VLOOKUP(C2,'New Held Batches Sheet'!$C$8:$D$22,2,0),,2)+ and so on)=1 or 2
why not =VLOOKUP(C2,'New Held Batches Sheet'!$C$5:$D$35,2,0)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks