Name look up

M

Mark_F

Hi, everyone.

I have a multi-worksheet workbook. Each worksheet ("Sheet2", "Sheet3", etc)
contains a crew of individuals with hours worked in a day. Generally, those
individual's names do not change. However, sometimes someone is not there. On
my first worksheet ("Summary") I've figured out how to do a VLOOKUP formula
off the worksheet to accumulate the hours. But because the names of the
individuals might change I need a suggestion for my "Summary" sheet to either
put the new name in or some alternative so the name will appear. Any
suggestions would be much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to refer to tab names? 1
search & return items by ws name 2
Relative worksheet reference clarified 4
Looking up values on another worksheet 1
using the Excel generic worksheet names instead of user-given names in code 5
Help changing the sheet name 3
Locking Pages and/or Workbook 1

Top