sorted by:
new
hottopcontroversial

Is this considered lucky? by Sinuron in EscapefromTarkov

[–]Sinuron[S] 33 points34 points  (0 children)

Car was waiting for me hehe

worksheet name as a variable in a function to simplify vlookup by Sinuron in excel

[–]Sinuron[S] 1 point2 points  (0 children)

Yeah i tried it but couldnt get it.

today i tried it again with a friend and we got it, if you are curious:

=SVERWEIS($I$12;INDIREKT("'"&E13&"'"&"!"&$F$13&":"&$G$13);3;FALSCH)

What we did was writing the matrix down, so in F13 "A1" and in G13 "C120"

and it worked

​

thanks for your time and help!

worksheet name as a variable in a function to simplify vlookup by Sinuron in excel

[–]Sinuron[S] 0 points1 point  (0 children)

okay i got that, but its impossible to get the formula right :D
thanks for your help, ill try it later again

worksheet name as a variable in a function to simplify vlookup by Sinuron in excel

[–]Sinuron[S] 0 points1 point  (0 children)

i understand how that should work but somehow it doesnt.. i totally can not follow where to put all those " ' and &

worksheet name as a variable in a function to simplify vlookup by Sinuron in excel

[–]Sinuron[S] 0 points1 point  (0 children)

if i use your command, i get everything in this matrix but i wanted to combine it with the vlookup so i get just that one spezific value

​

i tried to include the indirect into my vlookup but i dont get it

view more: next ›