Excel help - fetching data

[AHarvey]

Hi all,

I have created a spreadsheet that outputs a shift report to a notepad doc so it can be uploaded to a forum.

I've been asked to add some things in but it's caused an issue.

I have 2 sheets, one called "Shift Promo Planner" and the other called "promo info"

Shift promo planner has drop down lists created with the validation tool, it limits the options people can choose by reading from lists in the promo info sheet.

Before we had one job = 1 person, but now some of the jobs require 2 people. I've added an column next to the job list and entered the people required.

At the moment, the 'people' column is just entered as 1 all the time, I need to make it read the job cell, run off to the list and fetch back how many people it needs.

I hope that is clear, it's rather complicated

Anyone know how I can make it do this?

 

[Bint Box]

If I have understood it correctly, could you not link the cells in the "peoples" column to the appropriate cells in the "job" column either in a row basis or with a VLOOKUP function?

You can add conditions etc to the VLOOKUP so that it only returns a value subject to certain conditions.

It might be a bit clearer if you could paste an example as I am not sure if I have understood correctly what you are trying to achieve.


Rgds
Binty

 

[AHarvey]

thanks for the input, vlookup was close but I don't think it would have worked.

However, as there are only 4 jobs that need 2 people I managed to write a quick IF statement that does the job

thanks again

 

[Bint Box]

thanks for the input, vlookup was close but I don't think it would have worked.

However, as there are only 4 jobs that need 2 people I managed to write a quick IF statement that does the job

thanks again

Ure welcome, pleased that you got it sorted.


Rgds
Binty