Forum Discussion

Connor Smith's avatar
Connor Smith
Copper Contributor
Aug 23, 2018

pull data (from a different sheet)

I am attempting to pull data from the 1st spreadsheet to generate a report. However, it needs to be different based on the clients name.

1 Reply

  • Philip West's avatar
    Philip West
    Steel Contributor

    Hia

    'index match' can do that for you. If you google index match a lof of detailed tutorials will come up and I would recommend going through one and understanding how and why it works. It's very useful.

     

    I've attached a copy of your work book with an example of it working.

Resources