Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to use excel vlookup?

user-image
Question ajoutée par ANANDAN Kannaiyan , Senior Executive Project Implementation , Sitics Logistics solutions Pvt Ltd
Date de publication: 2017/03/07
jhangeer bazmi
par jhangeer bazmi , Freelance Graphics Designer

Well this function is used to lookup a value, to follow these steps mate:

  1. add a new column in worksheet which will show the information from the lookup table
  2. place your pointer in the first column blank cell of that column
  3. go to formula tab
  4. select insert function
  5. in the search for function : text box , type "vlookup" and click go
  6. highlight the vlookup and click ok
  7. Done

Regards.

More Questions Like This