Data

Discussion in 'CP2' started by Dar_Shan0209, Mar 1, 2019.

  1. Dar_Shan0209

    Dar_Shan0209 Ton up Member

    Hello,

    Makes as if I am now working in my model and I want to extract my data which is in the data checks worksheet. Which one is more preferable:

    - VLOOKUP to bring the data in
    - link via formula, for e.g. 'Data'!B4

    As far as I know, most of the sheets should be hardcoded and not 'typed in'.

    Regards,
    Darshan
     
    Dar_Shan0209, Mar 1, 2019
    #1
  2. David Hopkins

    David Hopkins Member

    Hi Darshan
    You can just use ='Data'!B4 here. This is easiest and it is what the examiners will expect.
    David
     
    David Hopkins, Mar 1, 2019
    #2
  3. Dar_Shan0209

    Dar_Shan0209 Ton up Member

    Hello David,

    Thank you for your help.

    Kind Regards,
    Darshan
     
    Dar_Shan0209, Mar 3, 2019
    #3

Share This Page