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.