C
cmyers
I am trying to find out if is possible to take 2 different spread sheets and compare 2 columns in a range. If it finds a match copy info from a cell from spreadsheet “A†into spreadsheet “Bâ€
Ex.
Agent spreadsheet A Agent spreadsheet
A1 agent name B1 User ID C1) Agent Name D1) user I
A2 smith, Bob B2 bsmith C2) Roy, Kill D2
A3 Doe, John B3 Jdoe C3) Smith, Bob D3) bsmit
l
end result
I need to compare agent name in spreadsheet A to Agent name in spreadsheet B if it finds a match then take the user id in spreadsheet A and copy it to spreadsheet B column D3.
Thank
Ex.
Agent spreadsheet A Agent spreadsheet
A1 agent name B1 User ID C1) Agent Name D1) user I
A2 smith, Bob B2 bsmith C2) Roy, Kill D2
A3 Doe, John B3 Jdoe C3) Smith, Bob D3) bsmit
l
end result
I need to compare agent name in spreadsheet A to Agent name in spreadsheet B if it finds a match then take the user id in spreadsheet A and copy it to spreadsheet B column D3.
Thank