Lookup Functions
Closed
Art_Vandelay
Posts
1
Registration date
Wednesday November 4, 2015
Status
Member
Last seen
November 4, 2015
-
Nov 4, 2015 at 02:58 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 5, 2015 at 10:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 5, 2015 at 10:49 AM
I have a spreadsheet with various tabs including data which has been dumped in from various sources. Data includes: worked hours by department, and productive statistics corresponding to that respective department. I'm trying to create a template with minimal upkeep. Is there a way to set up the productivity sheet listing the departments and enter a formula that "searches" the worked hours tab and finds, for example, "finance" and returns the hours value associated with that?
Related:
- Lookup Functions
- Https //accounts.google.com/sign in/v1/lookup - Guide
- Area code lookup - Guide
- Accessor functions c++ - Guide
- Hard disk parts and functions - Guide
- Excel functions in french - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 5, 2015 at 10:49 AM
Nov 5, 2015 at 10:49 AM
Hi Art,
You might want to take a look at the VLOOKUP formula.
If you require more assistance, then provide some sample data.
Best regards,
Trowa
You might want to take a look at the VLOOKUP formula.
If you require more assistance, then provide some sample data.
Best regards,
Trowa