I would like to further advance some search formulas. I have attached my workbook.
The Search page allows the user to search all the records on the ReturnData page based on the criteria entered into E1-E7. The search formula is located in the C column on ReturnData, which looks like this:
and then the results are ranked in the B column:
Then displayed on the Search page using the following formula:
How could the formula be written so that if cell B1 on sheet SearchSettings equals 1 then it hides the records from the search results where E equals Lost, but if its 0 then it performs as normal.
Also if cell B2 on sheet SearchSettings equals 1 then it hides the records from the search results where E equals Damaged, but if its 0 then it performs as normal.
My plan is to have a userform edit those cells, allowing the user to easily show or hide those records.
Bookmarks