Cant get Vlookup to work correctly

[dtavangar]

Hi I am trying to match 2 lists together to see if same order numbers from COLa exist in COL B I have been battling with this for hours and everytime it looks good I sort by N/A and some of the items in COl A still exist in COL B but it sayd N/A.

please see sheet attached any help is appreciated.

link to spreadsheet: https://docs.google.com/spreadsheets/d/1gY6WnXPzk_gEGJCg20uj2EK6Ev5VZirc3gEeCdbrvPk/edit?usp=sharing

 

[Aladin Akyurek]

What is the formula you have tried?

 

[HappyMeal]

Nothing is wrong with that formula. are you sure that it is not picking them up it looks like it is.

 

[dtavangar]

the formula is <bdo dir="ltr">=VLOOKUP(A2,B:B,1,FALSE) also yea i am sure the value exist, because when i do a copy and search for the same number it finds it in the other row but still the result is N/A I even thought it could be that the data type is off so I set both columns to general 00, but still no luck</bdo>. as an exaple look at this value in COL A <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>179354649014 and it COL C says N/A but it's still in COl B so this should not be N/A

 

[MARK858]

With the one you are quoting (179354649014) they are not the same. A4 is text because it has a leading space or non-printing character and B562 is a number because it doesn't have a leading space or non-printing character.

Edit: select Column A, click data - text to columns, click next twice, check General is checked and click finish.

 

[dtavangar]

oh yea! how can I change it so they are both the same? i tried to select all 3 COLS and right click and change the value to "format cells" but that didnt work.

 

[MARK858]

See my edit in the previous post

 

[dtavangar]

that worked!! thank you so much!