Formula Help!

[Deb Schwichtenberg]

Hello!  I have 2 columns of different numbers where if the last 4 digits of col 1 match the last 4 digits of col 2, then the number in col 2 should show up in col 3.  I think this should be a vlookup formula but not sure how to write it.  Please help!

Thanks

Deb

[#2]

Hi Deb,

For data like this

it could be

=IFERROR(INDEX($B$1:$B$4,MATCH(1,INDEX(--(RIGHT($A1,4)=RIGHT($B$1:$B$4,4)),),0)),"")

Attached