LinkBack URL
About LinkBacks
Try
=IF(IFERROR(SMALL(INDIRECT("'" &G2 &"'!$M$6:$M$326"),B6)," "),IF(SMALL(INDIRECT("'" &G2 &"'!$M$6:$M$326"),B6)<=249,SMALL(INDIRECT("'" &G2 &"'!$M$6:$M$326"),B6),""))
Try
=IF(IFERROR(SMALL(INDIRECT("'" &G2 &"'!$M$6:$M$326"),B6)," "),IF(SMALL(INDIRECT("'" &G2 &"'!$M$6:$M$326"),B6)<=249,SMALL(INDIRECT("'" &G2 &"'!$M$6:$M$326"),B6),""))
it works thanks, but also returns #VALUE! if the cell is empty.. way to get rid of that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks