referencing data to a table

  • Thread starter Thread starter tradebox
  • Start date Start date
T

tradebox

I have a table reflecting how many members of staff are required per 450
customers. The first column therefore contains 450, 900, 1350, 1800 etc.
Adjacent each customer break is the number of staff required, 10, 20, 30, 40
etc. I want to create an equation which looks at a separate cell containing a
random number, reference this to the customer table and tell me how many
members of staff are required.
 

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

Back
Top