I can't see what I'm doing wrong with this.
This Doesn't Work
=Vlookup(L2,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_Le0cMfbHRSgXqhCdzjQrBscFNm6p1sL-DowWdCZ0Fs/edit#gid=1761671943","responses!B2:R8"),4,0)
I get this error:
Did not find value '102' in VLOOKUP evaluation.
This Does Work
=Vlookup(102,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_Le0cMfbHRSgXqhCdzjQrBscFNm6p1sL-DowWdCZ0Fs/edit#gid=1761671943","responses!B2:R8"),4,0)
I get the correct value.
The only difference is the first version (not working) uses a cell reference L2
in the VLOOKUP. The second version (working) uses a static value 102
in the VLOOKUP.
I've tried wrapping in "
and '
but neither work.
Can someone please help me fix this so it works with a cell name and explains why my solution isn't working?
=arrayformula(SUBSTITUTE(K2:K,"#",""))
so I guess I need to figure out how to make this return a number instead of text?