Forum Discussion
Formula Help!
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...
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