| 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. |
| 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 | |||
Threaded Mode
