I would think that you'd only use a single cell as that first parm's value:
=IF(ISNA(VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,
VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE))
But if you want to bring back the value in column and match the value in column
B:
=index('duties mon-fri'!$a$2:$a4994,match($b$2,'duties
mon-fri'!$b$2:$b$4994,0)))
You may want to check for an error first:
=if(isna(match($b$2,'duties mon-fri'!$b$2:$b$4994,0)),0,....
Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble
Steved wrote:
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,'D uties
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.
--
Dave Peterson