I’ve a spreadsheet that I am utilizing to maintain monitor of stats for gamers in a league. That is the hyperlink:
https://docs.google.com/spreadsheets/d/193GxNzaX4-bGrNB8eT4vhqAOKhUrChRDgq-HYVU_Txk/edit#gid=1738544316
What I am attempting to have it do, is search the “Stats Gathering” sheet for the worth within the C
Column. When it finds that worth, I need it to return the worth of the A
Column on the “Stats Gathering” sheet, i.e. their identify.
I appeared up a information on youtube and it instructed me to importrange, which i did. That is the method I have been utilizing:
=VLOOKUP(C3, importrange("193GxNzaX4-bGrNB8eT4vhqAOKhUrChRDgq-HYVU_Txk", "Stats Gathering!A3:W43"), 1, FALSE)
Any concept what I am doing improper?
EDIT: Forgot to say. The error it is giving says it might probably’t discover the worth ‘10.5’ in VLOOKUP analysis. So basically, something within the C
column, it says it might probably’t discover it within the importrange, regardless that it is in there.