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