Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can we apply two vlookups together on a single cell?

HOW CAN WE APPLY TWO VLOOKUP ON SINGLE CELL

Microsoft Excel
user-image
Question added by Nitin Johri , Analyst , British Telecom Global services ltd
Date Posted: 2016/12/18
Upvote (0) Views (5) Followers (3) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

if I get your question correctly 

you can use:

  1. concatenate
  2. logical operators functions OR(),  AND() ...

Vivek V P
by Vivek V P , Accounts Associate , Ford Motor Private Limited

         

 

sd

100 120     f 400123 f 400 123    sd 100120

 

I used below formula in a single cell to get the results in E1, if you consider "sd" is in Cell A1 and accordingly.

=VLOOKUP(D1,A:B,2,0)&VLOOKUP(D:D,A:C,3,0)

 

Write Your Answer
More Questions Like This