Copy date for specific job Number

[shbilalcom]

[TABLE="class: grid, width: 400, align: left"]
<tbody>[TR]
[TD]No.[/TD]
[TD]Date[/TD]
[TD]Job. No.[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]3/5/2016[/TD]
[TD]456[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4/5/2016[/TD]
[TD]454[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5/5/2016[/TD]
[TD]455[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6/5/2016[/TD]
[TD]457[/TD]
[/TR]
</tbody>[/TABLE]










2nd Sheet

[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD]Job. No.[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]454[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]455[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]457[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want to copy cell value from date column of 1st sheet if another cell in same row have "sample" value

 

[shbilalcom]

can it find date automatically from 1st sheet against each job number

 

[sheetspread]

Yes, with index/match or vlookup(choose())

Excel 2010
	A	B	C
1	No.	Date	Job. No.
2	1	3/5/2016	456
3	2	4/5/2016	454
4	3	5/5/2016	455
5	4	6/5/2016	457
6
7	Job. No.	Date
8	454	4/5/2016
9	455	5/5/2016
10	456	3/5/2016
11	457	6/5/2016
Sheet9

Cell Formulas
Range	Formula
B8	=INDEX($B$2:$B$5,MATCH(A8,$C$2:$C$5,0))

 

[shbilalcom]

Thank you so much, i have one more issue now, if the date is blank it shows 9Jan1900 date, is it possible to keep it also blank if the date is blank on 1st page

 

[T. Valko]

Thank you so much, i have one more issue now, if the date is blank it shows 9Jan1900 date, is it possible to keep it also blank if the date is blank on 1st page

What version of Excel are you using?

 

[shbilalcom]

Excel for MAC v15.11.2

 

[T. Valko]

Excel for MAC v15.11.2

I'm not familiar with Mac versions.

If you have the IFERROR function available try this...

=IFERROR(1/(1/INDEX($B$2:$B$5,MATCH(A8,$C$2:$C$5,0))),"")