Hi,
I would like to indicate the location of where an exam took place based on the first three letters of the exam accession number. I created a list to use as a lookup but don't know how to write a formula only using the first 3 letters in the cell as the search criteria.
In the first cell: LSK130012 / The adjacent cell would return Echo, or LSM1300130 would return MRI in the adjacent cell.
There are 7 modalities in all that I would need to search for.
See the attached for the desired results
Last edited by xrayexceller; 08-05-2013 at 11:03 PM.
Try this, copied down...
=VLOOKUP(LEFT(A2,3),$J$2:$K$8,2,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you, exactly what I was looking for.
Happy to help
Attachment 255696Attachment 255696Vertical Look Up really helps in these scenarios.Originally Posted by FDibbins
Happy to help
Below formula really helped to obtain the objective. Thanks for this.
=VLOOKUP(LEFT(A2,3),$J$2:$K$8,2,0)
As I was trying with MATCH & INDEX formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks