All solutions HelpVLOOKUP Expert Solution – Help on VLOOKUP Problems

Excel - Help on VLOOKUP Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Need help with Multiple Vlookup Function. Please only Expert Require.
Solved by Z. J. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/09/2018 - 10:18
Hello, Welcome to Got it Pro.
Excelchat Expert 07/09/2018 - 10:18
How may I help you today?
User 07/09/2018 - 10:18
[Uploaded an Excel file]
User 07/09/2018 - 10:19
Please have a look on Cell D2. I have tried the Formula =VLOOKUP(B2,$B$8:$D$12,3)
User 07/09/2018 - 10:20
Are you there?
Excelchat Expert 07/09/2018 - 10:20
Yeah was looking at your sheet
Excelchat Expert 07/09/2018 - 10:20
your table has same data
User 07/09/2018 - 10:20
But it doesn't give the Result i.e. I require 04 Values as I have written there Manually but it's giving only 01 Value. I think an Array Formula might work but don't know.
User 07/09/2018 - 10:20
Please don't use TEXTJOIN Formula
Excelchat Expert 07/09/2018 - 10:20
B8 to B12 ...col B has Liability only
Excelchat Expert 07/09/2018 - 10:21
wait. go step by step
User 07/09/2018 - 10:21
Bring the Result in D2 Cell via Formula
Excelchat Expert 07/09/2018 - 10:21
I am confused with data and what you are trying to say, so go step by step now.
Excelchat Expert 07/09/2018 - 10:22
You have a table B8- F12
Excelchat Expert 07/09/2018 - 10:22
right?
User 07/09/2018 - 10:22
yes
Excelchat Expert 07/09/2018 - 10:22
Col B and C has same values in the table, right?
User 07/09/2018 - 10:23
Wait a minute
Excelchat Expert 07/09/2018 - 10:23
now come to the D2
Excelchat Expert 07/09/2018 - 10:23
sure
User 07/09/2018 - 10:24
[Uploaded an Excel file]
User 07/09/2018 - 10:25
Can you see Blue Highlighted Cell ?
Excelchat Expert 07/09/2018 - 10:26
yeah
Excelchat Expert 07/09/2018 - 10:26
so you want all four values in one cell?
User 07/09/2018 - 10:26
Yes
Excelchat Expert 07/09/2018 - 10:26
what value you are looking up?
User 07/09/2018 - 10:26
But Don't use TEXTJOIN formula
User 07/09/2018 - 10:27
B2
Excelchat Expert 07/09/2018 - 10:27
what is your purpose?
User 07/09/2018 - 10:27
Please have a look on Cell D2. I have tried the Formula =VLOOKUP(B2,$B$8:$D$12,3)
Excelchat Expert 07/09/2018 - 10:27
because you have to handle this with concatenation only
User 07/09/2018 - 10:27
No.
User 07/09/2018 - 10:27
It's just a Sample Sheet
User 07/09/2018 - 10:28
I basically need to Import data from Different Sheets
Excelchat Expert 07/09/2018 - 10:28
let me explain you there are only two possibilities in excel to handle this
Excelchat Expert 07/09/2018 - 10:29
1.) if you want to handle this with excel formulas, you have to add another column in the table and need to concatenate the values in one cell and then use vlookup to get that value. Because excel does not handle multiple formulas in one cell.
Excelchat Expert 07/09/2018 - 10:30
2.) you can use macro/ vba coding at back end and then you can get all the values in one cell without writing any formula in the cells.
User 07/09/2018 - 10:30
:(
Excelchat Expert 07/09/2018 - 10:30
what you are trying to do can only be handle with coding.
User 07/09/2018 - 10:30
Excel can !
User 07/09/2018 - 10:31
Excel Formulas Can !
Excelchat Expert 07/09/2018 - 10:31
Excel provides macro coding option
Excelchat Expert 07/09/2018 - 10:31
With excel formula you can get multiple values in one cell only with concatenation.
Excelchat Expert 07/09/2018 - 10:31
there is no other way
Excelchat Expert 07/09/2018 - 10:31
wait
User 07/09/2018 - 10:32
Ok.
Excelchat Expert 07/09/2018 - 10:33
Can you see I printed two values in one cell E2?
User 07/09/2018 - 10:33
But they are same
Excelchat Expert 07/09/2018 - 10:33
that is fine, I am just giving you an example
Excelchat Expert 07/09/2018 - 10:33
this gonna work for you?
User 07/09/2018 - 10:33
Can you modify it as: "Don't include previous one"
Excelchat Expert 07/09/2018 - 10:34
means, you only want the second value?
User 07/09/2018 - 10:34
I mean in first vlookup first value, in second, second value and third, third value and so on
Excelchat Expert 07/09/2018 - 10:35
we can do that but not in one cell need to create the logic and need to add one more column in the table
User 07/09/2018 - 10:35
Please take your time and create logic
Excelchat Expert 07/09/2018 - 10:35
Excel vlookup always look for unique values (primary key)
Excelchat Expert 07/09/2018 - 10:35
ok
User 07/09/2018 - 10:35
It also works for other too
Excelchat Expert 07/09/2018 - 10:36
yeah, it will work anywhere as far as the logic is fine.
User 07/09/2018 - 10:36
Please create logic then
Excelchat Expert 07/09/2018 - 10:38
See I have added col B
Excelchat Expert 07/09/2018 - 10:38
in data table
Excelchat Expert 07/09/2018 - 10:40
See in E2
Excelchat Expert 07/09/2018 - 10:40
your result is there for first 2 values
Excelchat Expert 07/09/2018 - 10:41
I added two column A and B in your base data and used a single formula in E2 to print those 2 values
Excelchat Expert 07/09/2018 - 10:41
Got it?
Excelchat Expert 07/09/2018 - 10:42
Are you with me?
Excelchat Expert 07/09/2018 - 10:43
Can you see all 4 values in one cell in E2?
Excelchat Expert 07/09/2018 - 10:58
I will appreciate a 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time. Thanks for using Got it Pro. Looking forward to help you further. Appreciate it :) Have a good day.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc