paste the first 20 rows of your data ie where the 736 is and the lookup on here - we can copy it and test it
ie A3=736 G3=736 H3 = fred (g and h being in the lookup table
Okay this is from the lookup sheet called SENORITY (yes they misspelled the file name) I copied some before and some after if that helps. Note I did not copy the employees job as it is in a column after some info that is confidential. I copied consecutive info only. if you want to test out job, you can just make up a job name if you want. That column was working fine anyway.
[TABLE="width: 188"]
<tbody>[TR]
[TD]720[/TD]
[TD]BRANCHECK, ZACHARY[/TD]
[/TR]
[TR]
[TD]721[/TD]
[TD]CHURCHFIELD, JEREMY[/TD]
[/TR]
[TR]
[TD]722[/TD]
[TD]SHUPE, KEN[/TD]
[/TR]
[TR]
[TD]723[/TD]
[TD]PETROZZA, TYLER[/TD]
[/TR]
[TR]
[TD]724[/TD]
[TD]BRYNER, MONTY[/TD]
[/TR]
[TR]
[TD]725[/TD]
[TD]HIXSON, LARRY B.[/TD]
[/TR]
[TR]
[TD]726[/TD]
[TD]SOLAK, DAVID[/TD]
[/TR]
[TR]
[TD]727[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]728[/TD]
[TD]WALKER, ADAM[/TD]
[/TR]
[TR]
[TD]729[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]730[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]731[/TD]
[TD]GUZZIE, B[/TD]
[/TR]
[TR]
[TD]732[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]733[/TD]
[TD]ROBERTS, ANDREW[/TD]
[/TR]
[TR]
[TD]734[/TD]
[TD]FARALLY, AUSTIN[/TD]
[/TR]
[TR]
[TD]735[/TD]
[TD]HARROLD, ADAM[/TD]
[/TR]
[TR]
[TD]736[/TD]
[TD]LANCASTER, LEELAND[/TD]
[/TR]
[TR]
[TD]737[/TD]
[TD]BLASZKOWSKI, JACLYN[/TD]
[/TR]
[TR]
[TD]738[/TD]
[TD]POPEK, MICHAEL[/TD]
[/TR]
[TR]
[TD]739[/TD]
[TD]JONES, DAVID W.[/TD]
[/TR]
[TR]
[TD]740[/TD]
[TD]ESLARY, DARYL E.*[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And this is from the attendance sheet which I had to remove protection from to copy and paste this:
this one is the formula for the name:
=IF(A28=0,"",LOOKUP(A28,'X:\Group\Warehouse\Management\Perishable\[SENORITY.xls]SENIORITY'!$A$1:$A$999,'X:\Group\Warehouse\Management\Perishable\[SENORITY.xls]SENIORITY'!$B$1:$B$999))
There were a pair of {} before and after this but it disappears when I click inside the formula box to copy it if that matters.
This one is for the employees job:
=IF(A28=0,"",LOOKUP(A28,'X:\Group\Warehouse\Management\Perishable\[SENORITY.xls]SENIORITY'!$A$1:$A$999,'X:\Group\Warehouse\Management\Perishable\[SENORITY.xls]SENIORITY'!$E$1:$E$999))
I hope this is what you were asking for?
