Hi all,
I have the following function: =INDEX($H$1:$H$960; MATCH(LEFT(A2;3);$B$1:$B$960;0))
What I need to do is match the first 3 letters of A2 to the first three letters in the range B1:B960, then whatever row is matched in the B range must be taken by the index function, matched with the H column and have the word from the H column Output into the appropriate cell.
At first I was referencing all of cell A2 (no left function) and had no Problems but it turns out I need to only reference the first 3 numbers in A2 and match them to the first 3 numbers in the range B1:B960. Hope someone can help!
Thanks in advance!
-Kyle
Bookmarks