Hello,
I'm writing up a little Google Doc that deals with heroes from Heroes of the Storm. Just something simple to make me remember build paths until I get more use to the game. I am having troubles with one of my query searches as i'm trying to make the program more dynamic. My code is this:
=QUERY($A$1:$E$25, "Select D Where B = '"&'Hero Builds'!A1&"' AND C = '"&C1&"'")
My problem is C = '"&C1&"'" part. If i put C = 1 then it works fine and shows me the list of Talents at level 1 but it returns #N/A telling me that the query finished and had 0 results. If tried referencing the page itself and changing the format of C along with a few other issues but I still cannot figure out why my result is giving me back no results.
I have also made another page and typed in 1, then did the query search below the 1 where it referenced my written 1 and I still get the same problem back.
Bookmarks