S
Steved
Hello from Steved
I've got 2 worksheets
The sheets are called "Duties Mon-Fri" and "Mon-Fri"
=IF(ISNA(VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE))
The above works perfectly because I copied the information into Col E:E
Question please How do I get the information from Col A:A
I Thankyou.
I've got 2 worksheets
The sheets are called "Duties Mon-Fri" and "Mon-Fri"
=IF(ISNA(VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE))
The above works perfectly because I copied the information into Col E:E
Question please How do I get the information from Col A:A
I Thankyou.