Hi,
Need code/formula for following things
I have three excel sheet in a workbook called “Leads”, “Properties” and “Brokers”.
1) I want code/formula to look up for the mobile number column from sheet “Leads” column “Q” with sheet “Brokers” column “M”.
If any of the number in column “M” of sheet “Brokers” is matching with number in column “Q” of sheet “Leads” then need result in adjacent cell “Column R” of sheet “Leads” as Brokers Sheet contains following numbers [(****Matching Number)]
2) Similar code/formula to look up for the mobile number column from sheet “Properties” column “AN” with sheet “Brokers” column “M”.
If any of the number in column “M” of sheet “Brokers” is matching with number in column “AN” of sheet “Properties” then need result in adjacent cell Column “AM” of sheet “Properties” as Brokers Sheet contains following numbers [(****Matching Number)]
3) The above code/formula is needed to compare email for both the sheets “Leads” and “Properties” with sheet “Brokers"
Bookmarks