Retrieve chart data through H lookup

     

    Retrieve chart data through H-Lookup

     

    Steps to Follow:

     

  • Create drop down in N2 Cell through Data Validation
  • Copy the studen data in L4 to L11
  • Apply H Lookup Formula
  •