VLOOKUP to return value
I am trying to return a value in a sheet using data from one other sheet. Look up whether there is anything entered in the 3rd column OEM License Agreement. If true then return the Company Name, column 1. This is what I wrote:
=VLOOKUP({00 CF/CI OEM-Fab Agreements [MASTER] Range 4}3,{00 CF/CI OEM-Fab Agreements [MASTER] Range 4}1:is not blank) but it's not working.
Answers
-
I would try using index/match vs. the vlookup formula. If you can give me more details I could help you.
-
I agree, match / Index would be better.
Or alternatively add an additional column within the reference sheet that returns a value if the column is blank, and then run the search value for the VLOOKUP off the new column created, completely removing the need to use ISBLANK within the VLOOKUP Formula. With the Column formula option, you can even make sure that it is always populated.
-
Thanks for the feedback. I'm still learning Smartsheet and am not proficient. Based on my initial question above, can you provide a formula sample?
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!