information from Col A:A
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. |
information from Col A:A
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 |
information from Col A:A
Thankyou
"Dave Peterson" wrote: 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 |
All times are GMT +1. The time now is 12:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com