[Help Needed] vlookup formula

[tomsheng]

Sample file as attached, got the Combo ID column as format "General", and trying to get the case# by matching the Combo ID from the other sheet. However, no matter how to adjust the Vlookup, still get #N/A as result.

=VLOOKUP(E6, $A$6:$C$30,1,FALSE), return to #N/A


Also tried:

1. Tried ID Column "Data – Text to Columns" to remove blank and tab, #N/A
2. Tried set ID Column format as Text, #N/A.
3. Tried set ID Column format as Number, #N/A.
3. Tried =VLOOKUP(Value(E6), $A$6:$C$30,1,FALSE), #N/A.
4. Tried Multiply all of lookup values by 1.#N/A.

Thanks.

[FDibbins]

Hi and welcome to the forum

1st of all, vlookup cannot look "behind itself" - you cannot look for a value in column B and then try to retrieve a value from column A.
2nd, apart from maybe formatting as text, formatting has no affect on the actual contents of a cell, it is purely cosmetic.

Try this, copied down...
=INDEX($A$5:$A$30,MATCH($E6,$B$5:$B$30,0),1)

[Teethless mama]

Try it like this:

=INDEX(A$6:A$43,MATCH(E6,B$6:B$43,0))