Excel - LOOKUP Function Problem - Expert Solution

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

I need to analyse data and not always return the 1st instance of a lookup. Eg. I have an account number, ID number and a domain name There are instances where the same account and ID numbers on a row have a different domain name. My use so far always defaults to give me the 1st instance of that combination, but I need to return all domain names, either in one cell or separate cells Is this possible ?
Solved by Z. L. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 31/08/2018 - 04:34
Hello, Welcome to Got it Pro.
User 31/08/2018 - 04:34
hi
Excelchat Expert 31/08/2018 - 04:34
Can you send me the sheet or add the sample data at the right side of the screen
Excelchat Expert 31/08/2018 - 04:34
so that I can help you better
User 31/08/2018 - 04:35
let me pull a sample - bare with me
Excelchat Expert 31/08/2018 - 04:35
sure.
User 31/08/2018 - 04:38
Acc ID Domain A001 123ABC abc.com A002 234DEF def.com A003 345EFG efg.com A004 456FGH fgh.com A005 567GHI ghi.com A006 678HIJ hij.com A007 789IJK ijk.com A001 123ABC 123.com A002 234DEF 234.com
Excelchat Expert 31/08/2018 - 04:39
please paste at the right side of the screen.
Excelchat Expert 31/08/2018 - 04:39
in chat box formatting doesnt support
Excelchat Expert 31/08/2018 - 04:39
Can you see the sheet at the right side of this screen?
User 31/08/2018 - 04:39
so if I use lookups and rules for A001 & 123ABC - I always get back abc.com - but need to also know that 123.com is in the same account
Excelchat Expert 31/08/2018 - 04:40
Please paste the data at the right side of the screen and then explain.
User 31/08/2018 - 04:40
i can see the sheet yes
Excelchat Expert 31/08/2018 - 04:40
Thanks.
Excelchat Expert 31/08/2018 - 04:41
ok, got your problem
Excelchat Expert 31/08/2018 - 04:44
Can you see?
User 31/08/2018 - 04:45
in A - how do you get Excel to add a count to the account number ?
Excelchat Expert 31/08/2018 - 04:45
=B2&" "&COUNTIF($B$2:B2,B2)
Excelchat Expert 31/08/2018 - 04:45
I added one etc column before the table
Excelchat Expert 31/08/2018 - 04:45
and used this formula and it will give a number after the account
Excelchat Expert 31/08/2018 - 04:46
so if you have 2 or 3 or 4 same values also
Excelchat Expert 31/08/2018 - 04:46
it will add a number after that
Excelchat Expert 31/08/2018 - 04:46
I have highlighted the same values with yellow color
Excelchat Expert 31/08/2018 - 04:47
and then you can use the vlookup
Excelchat Expert 31/08/2018 - 04:47
Did it solve your query?
User 31/08/2018 - 04:48
so to be clear its adding a number to the acc no which then makes it unique to lookup against ?
Excelchat Expert 31/08/2018 - 04:48
right, that was the logic
Excelchat Expert 31/08/2018 - 04:48
because excel looks up the unique value
Excelchat Expert 31/08/2018 - 04:48
so we have to create the unique values
Excelchat Expert 31/08/2018 - 04:49
Is there anything else I can help you with?
User 31/08/2018 - 04:49
ok i think i follow thanks
Excelchat Expert 31/08/2018 - 04:49
Please end the session and provide a 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time.
Excelchat Expert 31/08/2018 - 04:49
Thanks for using Got it Pro. Looking forward to help you further. Appreciate it :)

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.