Comparing data in two columns and setting a value

Closed
jaccano Posts 1 Registration date Sunday March 3, 2013 Status Member Last seen March 3, 2013 - Mar 3, 2013 at 08:52 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Mar 5, 2013 at 11:15 AM
Hello,

I'm comparing data in a very big database. and want to assign a value to matching data. For example

A B c
tenant code tenant name name
con1 john smith jane long
con2 terry mitch john smith
con3 jane long terry mitch

so john smith has the code of con1 and terry mitch is con2 in column c are numerous lease charges for them but they aren't in any order I would like to enter their code in column d that they have assigned to them from column a. how do I do this? so i'm looking for their name in column b and then assigning the value to them from column a.


1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Mar 5, 2013 at 11:15 AM
Hi Jaccano,

Sounds to me you are in need of VLOOKUP.

For VLOOKUP to work some adjustments need to be made.
The column you want to search for names need to be before the column you want to retrieve data from.
Secondly the names need to be in alfabetical order.

I'm sure you can make the VLOOKUP formula work.

Best regards,
Trowa
0