Trying to work with some excel here.. And can not get my head around how to do stuff.
I have two sheets with data. Sheet1 consists of :
A B C
User UserID Area
Sheet2 consists of :
A
UserID
Sheet1:B may consist of the same userid on multiple rows. Sheet2:A has an ordered list without duplicated userid's
I would like to get the Sheet2:A userid matched against Sheet1:B. If matched, insert Sheet2:B userid into Sheet1:D (new column) on the matched row If above matched, and Area = 2, mark row with Color red.
Kind Regards Lars