I am trying to get user preferences from user profile to the reviews sheet for products. The form that adds data to reviews sheet does populates columns from products but not user sheet. I can use the lookup component in reviews sheet for each column on user profile but my concern is that it doesn’t sync back to sheets or create an array. Ultimate goal is to use images that will display user preferences on users review.
I tried query function: =QUERY(definedrange,“select P, Q, R, S WHERE B=‘email@example.com’”) . It works but I can’t replace the value ‘firstname.lastname@example.org’ with the cell value . Has anyone been successful in using QUERY or FILTER functions?
Any help is appreciated.