I am trying to do a vlookup formula. I have 2 columns of data. the first is a column of 6 digit numbers. The second is a column of sixdigit numbers followed by -1.
for example. in column A i may have 123456, and in column B i may have 123456-1
I need a vlookup that ignores the -1 (it is not always -1, it could be -2, -3, -4 etc.)
this is what i tried... but it failed... any ideas?
=IF(ISNA(VLOOKUP(A2,(LEFT(6)),C:D,2)),"No Match",(VLOOKUP(A2,(LEFT(6)),C:D,2)))
for example. in column A i may have 123456, and in column B i may have 123456-1
I need a vlookup that ignores the -1 (it is not always -1, it could be -2, -3, -4 etc.)
this is what i tried... but it failed... any ideas?
=IF(ISNA(VLOOKUP(A2,(LEFT(6)),C:D,2)),"No Match",(VLOOKUP(A2,(LEFT(6)),C:D,2)))