Shane,

Thanks so much for your help!

No, it didn't work - I got a #N/A in the cell.

The formula I used was something like (transferred it to OPen Office on my
Mac but created in Excel on my PC, but I think the actual form corresponds
with your example below):

=VLOOKUP('REPAIR ROTAS.XLS'!'Plymouth Staff'.$A$5;C5:AQ2000;39;FALSE)


Where have I gone wrong?

"Shane Devenshire" wrote:

Hi,

Move to the cell where you want the formula, and type =VLOOKUP(
click on the cell were the employees name appears, A5?. Type a comma, and
click on the sheet tab where the lookup table is, select all the data
starting with the Name column on the left and including all the column upto
the one you want to return, looks like D1:AQ2000 or something similar. Type
a comman and then the numeric position of the column you want to return, then
another comma and False)

=VLOOKUP(A5,'Scheduling Pots'!D1:AQ2000,39,FALSE)

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Zakynthos" wrote:

I have an employee's name in cell A5 on a SS called Repair rotas.xls on the
Plymouth Staff tab.
The Saturday rota for this employee, called 'Saturday C', is in cell D5.

The spreadsheet on whicih I wish to input this rota is called 'Scheduling
Pots' and Amy Banks is located in cell D1588 and the cell in which I want to
input 'Saturday C' is AQ1588.

Do I use VLOOKUP to get this result and, if so, what would be the form of
this function to return the above result?

Many thanks.