Forum Discussion

ilker_d's avatar
ilker_d
Copper Contributor
May 24, 2019

Berndvbatanker 

Thank you for your reply but I don't know what a VBA means.

Isn't there just a formula that I can add into cell B3?

Twifoo's avatar
Twifoo
Silver Contributor
May 24, 2019
Perhaps you need to manually enter your desired results, then attach your file again so I can understand the logic of the formula you need. Formula, not VBA, should be the default solution.
  • ilker_d's avatar
    ilker_d
    Copper Contributor
    May 24, 2019

    Twifoo 

     

    Hi Twifoo,

     

    I have filled in the data. So If you change Cell B1 (for example 0155) all data should change with it. 

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      May 24, 2019
      You can try this formula in B3, copied down rows:
      =IFNA(VLOOKUP(A3,1!A$3:E$10,
      MATCH(B$1,1!A$2:E$2,0),0),0)