Good afternoon everybody!
I am trying to analyse the data of a spread sheet into another and for that I ned to Vlookup cells and paste the values in the columns 3,4,5.
Seems eacy for now.
The problem is that I am looking for a strim of characters that need to be extracted frkm the place where I am rearching.
That is
I have =VLOOKUP(B4...) I have to find the value in B4 in the column E in another tab. However column E will not find the value it self but only when you split the character in that column E.
That is
=VLOOKUP(B4;....) where B4 is 00201
I am looking for that value in a column that has the following strings:
So, you must think, "You will never find it" sure. But I need to find it in the first 5 characters of those strings. See red
When it find it I just want the Vlookup to place a 1 in it, and not any value in the following or same columns.
You must also know that the value in B4 is actually the joint of: B4&D3, but that expression works inside the vlookup.
This is the furthest I have gotten but I cannot make it work:
=VLOOKUP(B4&$D$3;mid('SMS-Based Data Analysis'!$K$4:$K$142;1;5);1;FALSE)
Thank you very much in advanced!
PS: I have looked of rsimilar posts in the forum but I did not find the asnwers therefore I am openng a new threat
I am trying to analyse the data of a spread sheet into another and for that I ned to Vlookup cells and paste the values in the columns 3,4,5.
Seems eacy for now.
The problem is that I am looking for a strim of characters that need to be extracted frkm the place where I am rearching.
That is
I have =VLOOKUP(B4...) I have to find the value in B4 in the column E in another tab. However column E will not find the value it self but only when you split the character in that column E.
That is
=VLOOKUP(B4;....) where B4 is 00201
I am looking for that value in a column that has the following strings:
0040200000 |
0060300000 |
0020113411 0070500000 |
0340210540 |
0360311035 |
So, you must think, "You will never find it" sure. But I need to find it in the first 5 characters of those strings. See red
0040200000 |
0060300000 |
0020113411 0070500000 |
0340210540 |
0360311035 |
You must also know that the value in B4 is actually the joint of: B4&D3, but that expression works inside the vlookup.
This is the furthest I have gotten but I cannot make it work:
=VLOOKUP(B4&$D$3;mid('SMS-Based Data Analysis'!$K$4:$K$142;1;5);1;FALSE)
Thank you very much in advanced!
PS: I have looked of rsimilar posts in the forum but I did not find the asnwers therefore I am openng a new threat