View Single Post
  #4   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by 10ten92 View Post
really thank you for your answer :)

but my question was bad, here is the right question.

please check an attached file.

I need to match A - F cell and get a number from G cell if F contains

number compare to A.

Please help me
OK, I think I understand what you need now but I have a question. Would the number in A always have two additional numbers at the start?

So in A it shows as 00123 but in F it shows as 123?