In the first sheet, I’ve in the row A the column of the users, I’ve in row B the column of the users and the column C the PC hostname of the users.
In the second sheet I’ve the firstname and lastname in 2 column A and B and the software installed.
How to match the firstname and the lastname for get the hostname where the software has been installed.
I tried a double Vlookup :
I can not figure out