Vlookup from another sheet
I need to create a vlookup formula that tallies up the total number of times a certain value shows up in a chart under someones specific name from a separate sheet. Right now the formula is giving me a value but it is a random name from 1 column.
This is the chart that I am referencing: For example I am needing my vlookup to tell me that Robert Mason has "AI forecasting" listed 9 times, and CSK KDS listed 2 times and so on.
this is the chart that I am trying to put the vlookup formula into to return that information. but my formula is currently not populating any return value.
This is the formula that I have right now: =VLOOKUP([Primary Column]@row, {VPO Testing Chart Range 3}, 4, true)
Not sure how to pull in this information needed - I also do not have the function to do a pivot table.
Answers
-
You will probably need to use the function
COUNTIFS()
in your case.Robert Mason =
=COUNTIFS( [Primary Column]:[Primary Column],[Primary Column]@row, {AI Forecasting},[Column7]1 )
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!