lundi 23 septembre 2019

Excel - Get Yes/No value from a List

I have currently generated a sheet as shown in Table below to see the URL's of liked photos from a particular Instagram user on my page.

enter image description here

Now I want to create another Excel doc like this (BOOK2.XLSX) that auto-populates Yes/No if the Instauser (row) has liked the photo (column) referred to in Book1.XLSX

enter image description here

What is the formula that I should write in B3:C4?

Aucun commentaire:

Enregistrer un commentaire