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.
Figured it out..
vlookup.
=VLOOKUP(A2,O$2:S$4542,5,0)