Hey Everyone,
I'm sure what I'm thinking of is possible, but I am struggling with using VLOOKUP within a text string. Below in my example I need to compare the test name in column C to the test name in Column A. When a match is found I need it to fill in the corresponding numeric test code in column B into Column D. The problem I am having is that the names are not always exact. For example Lab 1 may call the test "Heavy Metals Profile Urine" and Lab 2 may call the same test just "Heavy Metals". Is there a way to match on partial words or begining words in a formula where there is a text string? or am I thinking in the wrong direction. Any guidance would be greatly appreciated
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>
I'm sure what I'm thinking of is possible, but I am struggling with using VLOOKUP within a text string. Below in my example I need to compare the test name in column C to the test name in Column A. When a match is found I need it to fill in the corresponding numeric test code in column B into Column D. The problem I am having is that the names are not always exact. For example Lab 1 may call the test "Heavy Metals Profile Urine" and Lab 2 may call the same test just "Heavy Metals". Is there a way to match on partial words or begining words in a formula where there is a text string? or am I thinking in the wrong direction. Any guidance would be greatly appreciated
Lab Test Name 1</SPAN> | Lab Test Code 1</SPAN> | Lab Test Name 2</SPAN> | Lab Test Code Match</SPAN> |
HLA B5701 Test</SPAN> | 6790</SPAN> | Cholinesterase, Serum</SPAN> | |
Cholinesterase</SPAN> | 24365</SPAN> | HLA</SPAN> | |
Heavy Metals Profile, Urine</SPAN> | 2345</SPAN> | Alkaline Phosphatase</SPAN> | |
CMV</SPAN> | 2345</SPAN> | Alkaline Phosphatase Bone</SPAN> | |
Lead</SPAN> | 86478</SPAN> | Lead, Blood</SPAN> | |
Selenium, Urine</SPAN> | 2145</SPAN> | Albumin, CSF</SPAN> | |
Tricyclic Antidepressants</SPAN> | 345</SPAN> | Heavy Metals </SPAN> | |
Albumin CSF</SPAN> | 967865</SPAN> | Selenium</SPAN> | |
Alkaline Phos</SPAN> | 12345</SPAN> | CMV Antibodies</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>