mardi 3 mars 2015

Excel: IF-Statement copying and pasting into new cells

So I got a Table with 3 Rows and many entries: Combo | Number | Email


This was given to me, this is what I need to compare my search to. Now I've made another table else where. Exported a set of Combo. And made my table like this


Imported Combo | Is Imp.Combo in master table?


Imported Combo is being checked against Combo, if it is in there, it'll be true otherwise false. What I need now is this. And I can only describe it in pseudocode, sorry.


Imported Combo | Is Imp.Combo in master table? | Number | Email



if(Is Imp.Combo in master table? = true){
Copy Number from respective Combo cell (= Imported Combo), paste in new cell in my table;}


Perhaps a picture can show it best: http://ift.tt/1Ecw3CI


Is anything like this possible?


Aucun commentaire:

Enregistrer un commentaire