I know I'm chaining a lot together here, but it's SO close to functional. Here is my formula with the doc address altered for privacy.
=ARRAYFORMULA(IF(ISBLANK($AE$3:$AE),(query(importrange("https://docs.google.com/spreadsheets/d/XXXDkgregmq16N91iBOjKcMH3B74w9PoEExrHRWGdaP4/edit#gid=1834499049","Brite Fills Lot Truncation!A1000:H"),"select Col2, Col6 Where Col1= '"&('14 oz Bottles'!$G3:$G)&"'"))))
In short, I want this formula to auto-fill into a sheet that collects responses for a Google Form. It cross references another sheet and returns data based on the value of the G column in my current sheet. The only issue is what is in bold above. This function ONLY returns the value that matches $G$3 in my current sheet, acting as if it's an absolute cell reference. I want it to be relative so that it fills each line based on whatever value is in the G cell on that row.
I would be thankful for any insight!