I have a spreadsheet that I'm using to keep track of stats for players in a league. This is the link:
What I'm trying to have it do, is search the "Stats Gathering" sheet for the value in the
C Column. When it finds that value, I want it to return the value of the
A Column on the "Stats Gathering" sheet, i.e. their name.
I looked up a guide on youtube and it told me to importrange, which i did. This is the formula I've been using:
=VLOOKUP(C3, importrange("193GxNzaX4-bGrNB8eT4vhqAOKhUrChRDgq-HYVU_Txk", "Stats Gathering!A3:W43"), 1, FALSE)
Any idea what I'm doing wrong?
EDIT: Forgot to mention. The error it's giving says it can't find the value '10.5' in VLOOKUP evaluation. So essentially, anything in the
C column, it says it can't find it in the importrange, even though it's in there.