Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to use lookup ?

Excel look up

Microsoft Excel
user-image
Question added by Shyamu tomar , Medical Transcription , Medanta the medicity hospital
Date Posted: 2018/03/06
Upvote (0) Views (2) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Deleted user

=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value,False). Exemple : If what your are looking for is in row E, and you want it in row A.  [B-E] = 4 rows, so it's =vlookup(A1,B1:E1000,4,False)

 

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help