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 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 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?

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
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
0