Comparing data in two columns and setting a value

[Closed]
Report
Posts
1
Registration date
Sunday March 3, 2013
Status
Member
Last seen
March 3, 2013
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
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

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
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