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 formula but not sure how to write it. Please help!
Thanks
Deb
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
