So here we have an example in Cell H6 “Martha Achock” and will get the Patient ID, Date of Birth, Site in H7,H8,H9 respectively. Below are the formulas which we need to write for getting these values:
Cell H7: “=VLOOKUP($H$6,$A$1:$E$17,2,0)”
Cell H8: “=VLOOKUP($H$6,$A$1:$E$17,3,0)”
Cell H9: “=VLOOKUP($H$6,$A$1:$E$17,4,0)”
This will get the respective VLOOKUP value for given Lookup value from the table_array.
Really this is very nice article…and this is easy to understand..