You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
aggi
I'm trying to return results using FILTER with two criteria and getting in a muddle.What I want:When 'unique id' = cell BK1 and 'location' = cell bk2, then show me all the 'products' which match that criteria from sheet 1, column hCHATGPT has saved the day (with a bit of editing)
=FILTER(Sheet1!$H$1:$H$1000, (Sheet1!$A$1:$A$1000=Sheet2!BK1)*(Sheet1!$B$1:$B$1000=Sheet2!BK2), "")
It only just occurred to me to tell it to have another crack using the FILTER function.