Hello! Fairly new to sheets and excel in general. I have a spreadsheet attached, that I would like to be able to filter/lookup based on what reference number I use in cell "B1".
I am currently using this formula (=FILTER(A16:Q29,O16:O29=B1)) in the upper table to return values in the master sheet below it (for now).
It is not able to find or return values when the cell has multiple lines of text in it. There is no way for me to change this master sheet and not have multiple lines at all, unfortunately
2 questions for this:
1: How can I look up "101" and it find the text value when a cell (example "O20") has multiple lines of text in the cell.
2: Is there a better way to look this up and return all relevant cell information?
The example has an upper table (my filtered values) and the lower master table of what it actually looks like.
Thank you so much!
Bookmarks