Forum Discussion

kosisme1's avatar
kosisme1
Copper Contributor
Dec 25, 2022

making a book list

HI, fairly new to excel and I am trying to make a book list containing book title, shelf location, author, and perhaps date published. It is for a bookcase with eight shelves and approx sixty books p...
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Dec 26, 2022

kosisme1 

This is a variant on HansVogelaar 's solution.

BookSearchλ([title], [author], [shelf])

= LET(
    isTitle,   ISBLANK(title)  + ISNUMBER(SEARCH(title,BookList[Title])),
    isAuthor,  ISBLANK(author) + ISNUMBER(SEARCH(author,BookList[Author])),
    isOnShelf, ISBLANK(shelf)  + (BookList[Shelf]=shelf),
    FILTER(BookList, isTitle*isAuthor*isOnShelf)
  )

 

kosisme1's avatar
kosisme1
Copper Contributor
Dec 29, 2022
Thanks for the rely, power query sounds ideal, is there any "how to" for this

Resources