Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
Information dependent on other information | Excel Programming | |||
Replace information based on existing information | Excel Programming | |||
Information from one cell pulls information from another cell | Excel Programming |