# Excel - COLUMN Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.