Question description:
This user has given permission to use the problem statement for this
blog.
from A1 to A200 I have a numbers of 30 digits
from B1 to B10 I have a numbers of 5 digits
how I can find in wich line from A first 5 digits is same with same number from B column
Solved by G. Y. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
24/03/2018 - 11:25
several time a week
Excelchat Expert
24/03/2018 - 11:26
Hello! Welcome to Got It Pro-Excel.
User
24/03/2018 - 11:26
hello thank you for your elp
User
24/03/2018 - 11:26
help
Excelchat Expert
24/03/2018 - 11:27
Well,can you share your file with us to make the solution for you instantly?
User
24/03/2018 - 11:27
no
User
24/03/2018 - 11:27
but
User
24/03/2018 - 11:27
I can show on a screen
User
24/03/2018 - 11:27
aproximatly what I need
Excelchat Expert
24/03/2018 - 11:27
Sure
Excelchat Expert
24/03/2018 - 11:28
You may give at least 5 to 10 samples for column A and B only so we can create a formula for you
User
24/03/2018 - 11:28
ok
User
24/03/2018 - 11:28
1 min
Excelchat Expert
24/03/2018 - 11:28
Thanks :)
User
24/03/2018 - 11:32
well
User
24/03/2018 - 11:32
need in column C
User
24/03/2018 - 11:32
all number from A
Excelchat Expert
24/03/2018 - 11:33
Okay, does your column B must contain 5 digits?
User
24/03/2018 - 11:33
wich start with 1000 or 4000 or 3300
User
24/03/2018 - 11:33
5
User
24/03/2018 - 11:33
yes
User
24/03/2018 - 11:33
no 4
Excelchat Expert
24/03/2018 - 11:34
Buy your column B contains 4 digit only, how can we compare your first-5 digit from column A
User
24/03/2018 - 11:35
you cAN DO WITH FIRST 4
User
24/03/2018 - 11:35
after I will change the formule just
Excelchat Expert
24/03/2018 - 11:35
So, we are going to compare first 4 digit only, instead of 5, right?
User
24/03/2018 - 11:36
yes
User
24/03/2018 - 11:36
I did just example here
User
24/03/2018 - 11:36
I can change now
Excelchat Expert
24/03/2018 - 11:36
Great, If they are the same, the result will just be True, then False if not, will it be fine with you?
User
24/03/2018 - 11:37
done
Excelchat Expert
24/03/2018 - 11:37
Ok, can you also give the expected result at column C?
User
24/03/2018 - 11:38
1 sec
User
24/03/2018 - 11:38
like that
User
24/03/2018 - 11:39
but my column A is very big
Excelchat Expert
24/03/2018 - 11:39
Yes, got it
Excelchat Expert
24/03/2018 - 11:40
On your row2, is it match in col B
User
24/03/2018 - 11:40
for example
Excelchat Expert
24/03/2018 - 11:41
And A3 does not have any match at column B, right?
User
24/03/2018 - 11:43
everyone from A wich have first 5 digitsa from any row from B , I want to transfer in column C
Excelchat Expert
24/03/2018 - 11:43
okay, if not found, what should happen?
User
24/03/2018 - 11:44
nothing, the column C will be empty
User
24/03/2018 - 11:44
normaly I have in column A like 200 numbers
Excelchat Expert
24/03/2018 - 11:44
Okay, thanks you. Please hold on few minutes to create the formula
User
24/03/2018 - 11:45
in column B aproximatly 10
User
24/03/2018 - 11:45
in column C I want to transfer just the number wich stars with firs digits from B
User
24/03/2018 - 11:46
SORRY FOR MY eNGLISH i HOPE YOU UNDERSTAND ME
Excelchat Expert
24/03/2018 - 11:46
Yes, no problem
Excelchat Expert
24/03/2018 - 11:47
Please give me few minutes to handle it
User
24/03/2018 - 11:47
OK
Excelchat Expert
24/03/2018 - 11:51
The formula to resolve this problem is now created. Please check if we got the expected output.
User
24/03/2018 - 11:51
yes is good like that
User
24/03/2018 - 11:52
can you write here a formula
Excelchat Expert
24/03/2018 - 11:52
Thanks
User
24/03/2018 - 11:52
I can not copy
Excelchat Expert
24/03/2018 - 11:52
Sure
User
24/03/2018 - 11:52
from the screen
Excelchat Expert
24/03/2018 - 11:52
For your C1, the formula will be like this
Excelchat Expert
24/03/2018 - 11:52
=iferror(if(vlookup(value(left(A1,5)),B:B,1,false)>0,A1,""),"")
User
24/03/2018 - 11:52
that all ?
Excelchat Expert
24/03/2018 - 11:52
yes
User
24/03/2018 - 11:53
thank you very very much
Excelchat Expert
24/03/2018 - 11:53
So, the formula of vlookup
Excelchat Expert
24/03/2018 - 11:53
My pleasure
User
24/03/2018 - 11:53
have a good day
Excelchat Expert
24/03/2018 - 11:53
Likewise
Excelchat Expert
24/03/2018 - 11:54
Thank you for coming at Got It Pro-Excel!
Excelchat Expert
24/03/2018 - 11:54
For any other Excel issues, please don't hesitate to come again. We will be glad to support you anytime.
User
24/03/2018 - 11:54
ok ok thank you
Excelchat Expert
24/03/2018 - 11:55
Please click "End Session" when everything is fine with us and kindly give your kind feedback for our service.
Excelchat Expert
24/03/2018 - 11:55
Big thanks once again :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.