Forum Discussion

ElamanSagynaliev's avatar
ElamanSagynaliev
Copper Contributor
Apr 14, 2020

VLOOKUP online Ecxel

Friends! I need your help. I need to pull data using the VLOOKUP formula from another document. I have online ecxel. Help me.

 

1 Reply

  • Skoets's avatar
    Skoets
    Copper Contributor

    Hi ElamanSagynaliev 

    I am searching for this to!

    what i have found (but not tested).

    1. https://www.stl-training.co.uk/download/forum/38923_Creating%20a%20query%20in%20excel%20-%20Sharepoint.pdf

    2. =VLOOKUP(C1,'https://sharepoint.com/(Just copy your adress)'!B:F,3,0)

    Again i have not tested it yet, but wanted to help as soon as possible.