jeudi 20 juin 2019

Applying IF conditional to 3 rows and returning another value of another cell if the condition met

I have 3 cells in a row filled with Usernames, and another cell in the same row filled with time, I want to make columns with these usernames Id and if the username Id found any of the rows then print the time in the formula cell. is there any way to achieve this? I tried MATCH and VLOOKUP the fail was painful.

I have attached an image as an example and I really appreciate your help as its very important for me.

Spreadsheet example

Aucun commentaire:

Enregistrer un commentaire