Forum Discussion

  • Yury Tokarev's avatar
    Yury Tokarev
    Steel Contributor

    Hi Rahul

     

    If your Student table is in A1:C8, and the Score table in E1:F5, your formula in C2 would be 

    =VLOOKUP(B2,$E$2:$F$5,2,1). Note that the last parameter is equal to 1. It is an approximate match, which is essential for the formula to work in your case. 

     

    Yury

Resources