Originally Posted by
tigeravatar
Yes, its just 2 pipes. That is so that the formula cannot accidentally find a keword that includes a pipe symbol (if you had any) since there's no reason to have a keyword with 2 consecutive pipes. a keyword with 1 pipe is plausible, so by itself it won't do.
Actually in this case, the || was meant to "virtually" fill blank cells in the keyword table with that symbol. Since the number of keywords beneath each category are not necessarily equal, it is necessary to do this virtual replacement... other the search formula will assume a blank is a legitimate "keyword" and every cell in column B that does not have a keyword in the first column of keywords, will take on the category that contains the first blank cell adjacent to a cell that is not blank to the left of it.
As a test, try this formula:
CSE confirmed and copied down.... if your E1:AG100 list has uneven filled rows, then you should see some cells with incorrect categories...
using Tigeravatar's version with the " " will yield 0 in those "non matching cells" if you were to take out the || substitution.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks