Vlookup - ignore first 6 digits

Hi guys, basically is there anyway that I can make this formula ignore first 6 digits of a code so the lookup will be the last 4 digits to lookup, for example 6440072282 the lookup value will basically be “2282” not sure how if incorporate that into the formula?
Thanks.

=IF(ISNA(VLOOKUP(C5,’CARD REGISTER’!A:C,3,0)), “”,VLOOKUP(C5,’CARD REGISTER’!A:C,3,0))

Try substituting C5 with RIGHT(C5,4).

Also, I don't think that your formula will work with the quotes that you have in it.

You want to use these "" not these “”.

Yeah it was just doing that from my phone for some reason, I’ll try that tho!

Doesn’t seem to work, just giving me a blank cell it’s not looking up 2282

Try:

=IFERROR(VLOOKUP(--RIGHT(C5,4),'CARD REGISTER'!A:C,3,0),"")

Originally Posted by Phuocam

Try:

=IFERROR(VLOOKUP(--RIGHT(C5,4),'CARD REGISTER'!A:C,3,0),"")

Now I’m getting #NAME? Hmm..

Are you using an Excel version earlier than 2007? If you don't have the IFERROR function, you can use this:

=IF(ISNA(VLOOKUP(--RIGHT(C5,4),'CARD REGISTER'!A:C,3,0)),"",VLOOKUP(--RIGHT(C5,4),'CARD REGISTER'!A:C,3,0))

Originally Posted by 63falcondude

Are you using an Excel version earlier than 2007? If you don't have the IFERROR function, you can use this:

=IF(ISNA(VLOOKUP(--RIGHT(C5,4),'CARD REGISTER'!A:C,3,0)),"",VLOOKUP(--RIGHT(C5,4),'CARD REGISTER'!A:C,3,0))

Yeah I am sorry, should of mentioned.. it’s working but is there anyway to get it to be blank if there’s nothing in c5? Currently showing #VALUE?

Change ISNA to ISERROR.