Hi,

I would like to know how to compare 2 columns and return a value from a 3rd column.

Scenario -
Column D contains random telephone numbers but missing the first digit
Column A contains more random telephone numbers but complete
Column B contains a numeric value
I want to compare Column D against Column A and if the value from column D is contained within any of the numbers in Column A then enter the value from Column B into Column E

For example
Column D - 1412323564
Column A - Could contain 01412323564 or 1412323564
Column B - 10101012
Value entered into column E is 10101012 if Column D is found in Colun A