Can you use a resource as the search-value in vlookup ?
Can you use a resource as the search-value in vlookup ?
Best Answer
-
You can use a resource. The issue is the closing curly bracket should be immediately after the range name, but you have it at the end of the formula.
Answers
-
Do you mean a name in a contact type column?
-
I have a project task sheet and assign resources to a task from my contact list. I have a separate sheet recording hourly rates for each person in the contact list.
The task has hours allocated to it, and I just want to lookup the hourly rate of the resource and multiply it by the hours to get a cost.
Iget an incorrect argument error and suspect its because I can't use the resource as an input (search item) in the vlookup formula. Would that be right ?
-
You can use a resource. The issue is the closing curly bracket should be immediately after the range name, but you have it at the end of the formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!