mercredi 24 décembre 2014

Excel column functionality

i was looking for a function in Excel to do the following thing.


I have a list with EAN codes (they're all in column A) with every EAN code there is a description of what it is (descriptions are all in column B) here is what i want, if i search for a EAN code lets say i set my search in "C1" i want it to search in column A that EAN code and set the description (what's in column B) of that EAN code in "D1".


Is this possible and how do i do this. I searched already but i can't find it. Maybe it isn't possible maybe it is. I hope someone can help me with this.


Aucun commentaire:

Enregistrer un commentaire