Simple Excel lookup

Discussion in 'General Discussion' started by Jason, Jul 7, 2008.

  1. Jason

    Jason Developer / Handyman Staff Member

    How do I get my patient's HealthNumber if it is on another Worksheet in Excel ?

    Really what I want to do is find the HealthNumber than corresponds to the Chart column.

    Attached Files:

    Jason, Jul 7, 2008
    #1
  2. Jason

    Jason Developer / Handyman Staff Member

    Figured it out..



    vlookup.



    =VLOOKUP(A2,O$2:S$4542,5,0)

    Jason, Jul 7, 2008
    #2

Share This Page