#no Match Error using VLOOKUP

Hello - What I'm trying to do is return the name of the team member that owns the workstream onto a different sheet. I went with the vlookup formula and keep getting a no match error. Details and screenshots below. I want the formula to look for BCG on screenshot 1 and look for it on a different sheet. If it finds it, return the "Team Member" in the contact field of Screenshot 1. Any thoughts?
Formula I am using: =VLOOKUP(Workstream@row, {Project Team - GES - 5% Workstream Range 4}, 9, false) (See screenshot)
Error I am getting: #NO MATCH
SCREENSHOT 1: This is the screen shot of the sheet I want the contact to be populated it.
This is the screenshot of the Range. Range is the entire sheet (see screenshot)
Best Answer
-
Hey @Bria Berger
When using the Vlookup formula, the field you are searching has to be the left most column in the sheet you are searching. So if I understood what you are saying correctly, you want the formula to search for the Workstream in the sheet screenshot 2 and then feed back the name of the team member to sheet in screenshot 1?
It could be giving you the #NoMatch error because it is unable to find that specific work stream in the left most column of your search range in screenshot 2.
You could try the Index Match formula to see if that works better. Try something like = Index({Team Member Column in Screenshot 2}, Match(Workstream@row, {work streamcolumn from sheet in Screenshot 2}, 0))
See if that works for you, if not let me know!
Answers
-
Hey @Bria Berger
When using the Vlookup formula, the field you are searching has to be the left most column in the sheet you are searching. So if I understood what you are saying correctly, you want the formula to search for the Workstream in the sheet screenshot 2 and then feed back the name of the team member to sheet in screenshot 1?
It could be giving you the #NoMatch error because it is unable to find that specific work stream in the left most column of your search range in screenshot 2.
You could try the Index Match formula to see if that works better. Try something like = Index({Team Member Column in Screenshot 2}, Match(Workstream@row, {work streamcolumn from sheet in Screenshot 2}, 0))
See if that works for you, if not let me know!
-
Thank you, Mary! That worked like a charm. I didn't know about using the Index Match formula so really appreciate the tip. THANK YOU!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!