Question description:
This user has given permission to use the problem statement for this
blog.
I need help using VLOOKUP. So I have my formula, and I know its correct but the problem I'm using a name as the lookup value, and the array I'm using has the same entry multiple times. So when I use VLOOKUP I get a #N/A error. How can I adjust this formula to display any one of the results
Solved by B. D. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/09/2018 - 01:39
Hello, Welcome to Got it Pro.
Excelchat Expert
14/09/2018 - 01:40
Please forward the working sheet or add the data at the right side of the screen so that I can help you better.
User
14/09/2018 - 01:40
I cant add the file, its confidential. But i just need help with my formula
Excelchat Expert
14/09/2018 - 01:41
You can add some sample data so that I can understand your problem
Excelchat Expert
14/09/2018 - 01:42
because if the lookup value is missing it will give #Value error not the #NA
Excelchat Expert
14/09/2018 - 01:43
You have a missing lookup value in the error. I can help you better if you can some sample data. Thanks.
User
14/09/2018 - 01:43
say I want to find jills student ID
User
14/09/2018 - 01:43
but there are multiple entries for jill
User
14/09/2018 - 01:44
how do i get my formula to display any one of the entries
Excelchat Expert
14/09/2018 - 01:44
ColA has ID, right? and which value you want as return? first?
User
14/09/2018 - 01:44
yes
Excelchat Expert
14/09/2018 - 01:44
ohh it's all same ID in the array
Excelchat Expert
14/09/2018 - 01:44
ok
Excelchat Expert
14/09/2018 - 01:45
Here you go
Excelchat Expert
14/09/2018 - 01:45
See col G and Col H
Excelchat Expert
14/09/2018 - 01:45
Does this solve your query?
User
14/09/2018 - 01:46
ye sthanks
Excelchat Expert
14/09/2018 - 01:46
Please end the session, 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.
Excelchat Expert
14/09/2018 - 01:46
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.