Hi
I have not used either of the formulas before but would like to learn the basics.
in my 2 worksheets, I have information about the same staff but each worksheet refers to different budget. I started entering on worksheet 1 if the staff is current or ex (column exited - if staff left there is date, if not it's blank), on worksheet 2 I have the same names of staff but where the staff used more than 1 budgets, I also created column called exited. I'd like to duplicate what is in the same column on worksheet 1 for each of the staff.
What function would I use and how please?
Worksheet 1 (values in cell B2:B8 were populated manually)
<tbody>
</tbody>
Worksheet 2 - the number times each staff will feature across the 2 worksheets will wary, also some staff will only be on 1 worksheet and not the other.
My desired outcome is to pull values from worksheet 1, column B, and duplicate them in worksheet 2, column B. I don't mind if they are on every row that belongs to that staff as long as it's there.
Desired outcome is shown in cell B2
<tbody>
</tbody>
Thank you very much, this seems like a headache to me but probably a very easy for you guys on here.
I have not used either of the formulas before but would like to learn the basics.
in my 2 worksheets, I have information about the same staff but each worksheet refers to different budget. I started entering on worksheet 1 if the staff is current or ex (column exited - if staff left there is date, if not it's blank), on worksheet 2 I have the same names of staff but where the staff used more than 1 budgets, I also created column called exited. I'd like to duplicate what is in the same column on worksheet 1 for each of the staff.
What function would I use and how please?
Worksheet 1 (values in cell B2:B8 were populated manually)
A | B | C | |
1 | Name | Exited | Budget |
2 | Poppins | March 18 | clothing |
3 | Jelly | clothing | |
4 | Jelly | clothing | |
5 | Jelly | clothing | |
6 | Mary | June 18 | clothing |
7 | Mary | June 18 | shoes |
8 | Mary | June 18 | shoes |
<tbody>
</tbody>
Worksheet 2 - the number times each staff will feature across the 2 worksheets will wary, also some staff will only be on 1 worksheet and not the other.
My desired outcome is to pull values from worksheet 1, column B, and duplicate them in worksheet 2, column B. I don't mind if they are on every row that belongs to that staff as long as it's there.
Desired outcome is shown in cell B2
A | B | C | |
1 | Name | Exited | Location |
2 | Poppins | March 18 | USA |
3 | Jelly | Sweden | |
4 | Jelly | Sweden | |
5 | Mary | Spain | |
6 | Mary | Spain |
<tbody>
</tbody>
Thank you very much, this seems like a headache to me but probably a very easy for you guys on here.