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?

 

[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