Index match or V look (or something else?)

[Jitka]

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)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Exited[/TD]
[TD]Budget[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Poppins[/TD]
[TD]March 18[/TD]
[TD]clothing[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jelly [/TD]
[TD][/TD]
[TD]clothing[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Jelly [/TD]
[TD][/TD]
[TD]clothing[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Jelly[/TD]
[TD][/TD]
[TD]clothing[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Mary[/TD]
[TD]June 18[/TD]
[TD]clothing[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Mary[/TD]
[TD]June 18[/TD]
[TD]shoes[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Mary[/TD]
[TD]June 18[/TD]
[TD]shoes[/TD]
[/TR]
</tbody>[/TABLE]

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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B [/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Exited[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Poppins[/TD]
[TD]March 18[/TD]
[TD]USA [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jelly [/TD]
[TD][/TD]
[TD]Sweden[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Jelly [/TD]
[TD][/TD]
[TD]Sweden[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Mary[/TD]
[TD][/TD]
[TD]Spain[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Mary[/TD]
[TD][/TD]
[TD]Spain[/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much, this seems like a headache to me but probably a very easy for you guys on here.

 

[Scott T]

Book1
	A	B	C
1	Name	Exited	Location
2	Poppins	18-Mar	USA
3	Jelly		Sweden
4	Jelly		Sweden
5	Mary	18-Jun	Spain
6	Mary	18-Jun	Spain
Sheet2

Cell Formulas
Range	Formula
B2	=IF(INDEX(Sheet1!$B$2:$B$8,MATCH(A2,Sheet1!$A$2:$A$8,0))=0,"",INDEX(Sheet1!$B$2:$B$8,MATCH(A2,Sheet1!$A$2:$A$8,0)))

Copy down

 

[Jitka]

Hi Scott,

Thanks very much for this, I'll study the formula so I can try and understand. Really appreciate your time. Apologies for the late response.
Kind Regards
Jitka