Hi All.
I have a formula that is looking for matching values in column A & B and aligning the matches for a in C:
I.E
A B C
1 2 1
5 - 5
2 1 2
4 5
The formula is: =IF(ISNA(MATCH(A8,B:B,0)),"",INDEX(B:B,MATCH(A8,B:B,0))) and works perfect.
Is there a way that I can use this formula to only search and match the first 5 characters of column A & B.
Ive tried using the left,6 but cant figure out where to insert it.
I.E
Column A / Column B / Column C
12345-A --- 12344-C --- 12345
12349-F --- 12342-A
12323-F --- 12345-B --- 12323
12992-A --- 12323-F
If I cant use my existing formula for this can anyone tell me one that will do the same function?
Along with this is it possible to run a conditional format to highlight the blank cells in column C?
Thanks!
Bookmarks