Nested vlookup

[Cat22]

I have a new worksheet:

Employee No. Name

Under the Name colum (B) i want a formula that uses the employee number (A) to look up the name. The problem i am having is that i need to look the name up from 3 other worksheets.

On worksheet 1 i have fridays work and 2 i have saturdays work and 3 sundays!! I only want a name to appear if they worked any one (or more) of these days. If they didn't work i would like the name to remain blank.

On all worksheets employee number and name arein colums A and B.
I do have another worksheet that has name and number only in though. worksheet 4!

Can anyone help?!?!

[martesoft]

I would just take the brute force approach

=IF(ISNA(VLOOKUP(B2,Sun!A:BN,2,FALSE)),IF(ISNA(VLOOKUP(B2,Sat!A:BN,2,FALSE)),IF(ISNA(VLOOKUP(B2,Fri!A:BN,2,FALSE)),"",VLOOKUP(B2,Fri!A:BN,2,FALSE)),VLOOKUP(B2,Sat!A:BN,2,FALSE)),VLOOKUP(B2,Sun!A:B,2,FALSE))

[Cat22]

thanks!! xxx