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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!